sqlrx logo
SQLRx® Tip of the Month
 
 
December 2009
Greetings!
 
As a DBA, make sure you monitor the 11 VitalSigns used by SQLRx to debug performance bottlenecks.
performance monitorPerformance Monitor: Monitor the performance counter PhysicalDisk (% idle Time) for each disk to find evidence of disk subsystem pressure. 
 
This counter records the percentage of time the disk was idle.
 
Disk performance degrades as this counter approaches zero.  If this counter reaches zero, no more I/O's can be processed, you may be experiencing slow performance.
 
Translate % Idle Time into % Busy Time with this formula: (100 - % Idle Time).
 
 

disk drive activity

 
__________________________________________________________________ 
SQLRx is now a part of www.msdev.com, Microsoft's training site for solution providers!  Check the site periodically to view new training videos.
 
If you have a SQL question you'd like us to answer, and possibly use for the next SQLRx Tip of the Month or msdev video, email it to us!  If you missed any of our previous tips, you can view them here.
 
For assistance or more information on optimizing your SQL Server Environment, visit us at www.sqlrx.com or email Lori Brown at lorib@isi85.com.  

Sincerely,

Lori Brown | SQLRx Senior Consultant | Integrated Services, Inc.
4144 N. Central Expwy, Suite 430  |  Dallas, TX  75204
Phone: 214.526.7680 x 113 | lorib@isi85.com 
 
 
Integrated Services, Inc.                                    
2008 winner logo small
Turning Data Into Profit
 
Over 20 Years of Credibility & Trust
 

Join our email list          Check out our events          SQLRx Downloads