THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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:

http://greglow.com/index.php/2009/04/22/timely-reminder-to-avoid-early-filtering-on-resource-usage-when-profiling-sql/

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

Comments

 

Uri Dimant said:

Greg

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

Regards

Jayant

09313406257

09313406257

April 22, 2009 5:03 AM
 

cinahcaM madA said:

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

SELECT TOP(10) *

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.

Regards,

Greg

April 27, 2009 3:27 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

Archives

Privacy Statement