Problem solve Get help with specific problems with your technologies, process and projects.

Step 2: Disk IO queuing

Disk activity is the second key general performance metric for SQL Server. Learn how to determine disk activity in this step.

In my opinion, disk activity is the second key general performance metric for SQL Server. To determine general disk activity, once again turn to Performance Monitor, which offers valuable disk drive counters for both physical and logical statistics. These include:

  • Physical Disk: % Disk Read Time
  • Physical Disk: % Disk Write Time
  • Physical Disk: % Idle Time
  • Physical Disk: Avg Disk Bytes/Read
  • Physical Disk: Avg Disk Bytes/Transfer
  • Physical Disk: Avg Disk Bytes/Write
  • Physical Disk: Avg Disk Queue Length
  • Physical Disk: Current Disk Queue Length

Another valuable resource that offers specific information related to the activity at a file level in SQL Server is master.dbo.fn_virtualfilestats. This function offers the disk IO statistics (reads, writes, etc.) for all database and transaction log files.

Hunt down SQL Server performance problems

 Home: Introduction
 Step 1: CPU usage
 Step 2: Disk IO queuing
 Step 3: Memory consumption
 Step 4: Network bandwidth
 Step 5: Transaction-level performance

Jeremy Kadlec
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also the Performance Tuning expert. Ask him a question here.
Copyright 2005 TechTarget
This was last published in December 2005

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.