Exploring SQL Server CPU Usage with Xperf

In previous blogs, we took a look at how to install Xperf, and how to use it to look at file I/O. For SQL Server administrators, a potentially important use of Xperf is to examine the consumption of CPU cycles, particularly when tools like the performance counters are showing high CPU use, but the reason […]
Read More ›

Examining SQL Server Xperf: The Performance Microscope

Xperf – The Performance Microscope The standard triad of SQL Server performance monitoring: Dynamic Management Views, performance counters, and trace, provide the bulk of the information necessary for routine performance data collection. There are times, however, when a more powerful tool is needed. Perhaps you need to determine exactly what tasks are causing a wit, […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.