The Disk Time (Percent) metric calculates the percentage of elapsed time during which all the disks were busy servicing read and write requests on the SQL Server computer. This counter is measured by subtracting the Disk Idle Time percent from 100. The WMI object Win32_PerfRawData_PerfDisk_PhysicalDisk property PercentIdleTime is measured to get Disk Idle Time percent.

Reduce disk time

If this metric value regularly exceeds 75%, consider the following solutions:

  • Check OS Paging to make sure that paging from/to the swap file is not causing these IOs.
  • Distribute the data and logs over more disks.
  • Replace disks with faster disks.
  • Add more memory if the main cause is Disk Reads.
  • Switch from a RAID 5 to RAID 10 solution if Disk Writes make up more than 20% of total disk access.
  • Move non-SQL Server applications to another computer.
  • If the computer is running multiple instances of SQL Server, consider placing each instance on a separate computer.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >