In this post, we will look at how to get information from the three other components which I had not covered in my last post, i.e. the IO Subsystem, Query Processing and System.
The IO Subsystem component will help you track IO Latch Timeouts, Number of long IOs reported by the SQL Server database engine and the longest pending IO that was reported along with the file name. This data is quite helpful in determining the issues related to I/O performance for the queries that are being executed against the SQL Server instance.
Read this article..
Amit currently works as a Premier Field Engineer at Microsoft specializing in proactive and advisory assistance for SQL Server environments.
In the past, Amit was part of the SQL Server Escalation Services team at Microsoft. His day-to-day work involves fixing and troubleshooting complex issues related to SQL Server over a varied range of environments, which could be a deployment handling just 100 users or 10 million users.
Over the years, he has learned various ways of slicing and dicing diagnostic data collected for troubleshooting and picked up a few tricks & tid-bits about the internals of this ever-evolving product called SQL Server.
For more information about Amit, visit his blog at http://troubleshootingsql.com.
comments powered by