Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

An Informal Look at Database Performance Expand / Collapse
Author
Message
Posted Wednesday, September 8, 2010 7:31 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, December 22, 2014 8:19 PM
Points: 4,474, Visits: 6,406
Nadrek (9/8/2010)
Nice overview; I'd like to encourage the addition of looking at SQL Profiler CPU, Reads, Writes, and Duration columns on SQL:BatchCompleted events.

Not only do these show aggregates, if you do this on a regular basis, you'll get a good, trained idea of when a query is using "too much" of any of them.


This is VERY helpful for anyone who has UDFs in their system too, since it is the ONLY way you can see how bad they really are.


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #982747
Posted Wednesday, September 8, 2010 7:33 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, December 22, 2014 8:19 PM
Points: 4,474, Visits: 6,406
I will add as a minor point that non-clustered index fragmentation (at least the extent kind) usually doesn't matter that much since the seeks tend to be random in nature anyway.

Nice coverage of many of the things to look out for.


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #982748
Posted Friday, September 10, 2010 11:35 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 3:32 PM
Points: 18,068, Visits: 16,111
Nice article. Thanks Tim.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #984253
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse