THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Timely reminder to avoid early filtering on resource usage when profiling SQL

This blog has moved! You can find this content at the following new location:

Published Wednesday, April 22, 2009 12:45 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Uri Dimant said:


Very good point. Last month I saw the almost same situation at my client's site, but the difference was that one of the table had a trigger which slows down performance. But the logical reads, CPU, duration as you mentioned on each call were close to zero...

April 22, 2009 12:27 AM

jayant said:

Dear Greg

point of my view create a job which shuld be mail to you that about Io stattitic of sql server that mail will contain logical and physical reads of query





April 22, 2009 5:03 AM

a.m. said:

Certainly a great point and one that a lot of people forget.  sys.dm_exec_query_stats has been especially useful here:


FROM sys.dm_exec_query_stats

ORDER BY execution_count DESC

April 22, 2009 10:32 AM

Shuwei Wu said:

What's the cache timeout mean here, do you mean it's the web application configuration?

April 23, 2009 1:29 AM

Greg Low said:

Hi Shuwei,

Specifically it was the timeout on the "Cache" object in the web app.



April 27, 2009 3:27 AM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement