Greetings!
Every DBA should monitor the 11 VitalSigns used by SQLRx to debug performance bottlenecks.
|
Performance 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. |