sqlrx logo
SQLRx Tip of the Month
 
 
September 2009
Greetings!
 
Every DBA should monitor the 11 VitalSigns used by SQLRx to debug performance bottlenecks. 
 
performance monitorPerformance Monitor: To measure the response time of the disk subsystem, monitor these performance counters for each disk to find evidence of disk subsystem pressure:

PhysicalDisk (Avg. Disk sec/Read)

PhysicalDisk (Avg. Disk sec/Write)

PhysicalDisk (Avg. Disk sec/Transfer)

These counters record the average time in milliseconds that disks are taking to satisify requests.

Best performance is 10 ms or less. If the average value is more than 0.020 (20 milliseconds), you may be experiencing slow performance. It might be time to tune queries or add more disks.
For assistance or more information on optimizing your SQL Server Environment, visit us at www.sqlrx.com or email Lori Brown at [email protected].  

Sincerely,

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

Join our email list