Monday, August 3, 2009

Key Performance monitor counters to identify performance problems

PhysicalDisk

  1. PhysicalDisk: Avg. Read Queue Length Should be less than 2
  2. PhysicalDisk: Avg. Write Queue Length Should be less than 2
  3. PhysicalDisk: % Disk Time more than 50% indicates a bottleneck
Reference: http://www.computerperformance.co.uk/HealthCheck/Disk_Health.htm

No comments:

Post a Comment

Failed to obtain the resource handle for cluster resource with name or ID 'xxxxxxxxxxxxxxx' error on Availability Group databases

We recently had failures for our Backup Maintenance Plan (performing T-Log backups) and it would fail with the below error message: Message ...