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

Display the list of indexes and columns for a given table

You might find yourself in a situation where you have to analyze the indexes for a given table and want to know which columns are part of wh...