Q
Problem solve Get help with specific problems with your technologies, process and projects.

Concerned with performance degradation

Performance information obtained from SP_WHO or Enterprise Manager Current Sessions dialog may not be entirely accurate. Expert Kevin Kline discusses the limitations of those utilities.

Even though the stored procedure or query executes successfully, it still shows CPU utilization and I/O utilization against that Service Provider Identifier (SPID). This seems to be causing some performance degradation. How can I avoid this?
You may not be experiencing any problems at all. If you're using SP_WHO or the SQL Enterprise Manager Current Sessions dialog, the CPU and I/O Utilization columns are cumulative. So even if you executed a query five minutes ago and have done nothing since, those columns will still show a value as of the last time your session did any work.


Do you have comments on this Ask the Expert Q&A? Let us know.

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close