Follow

How to Address Disk Fragmentation on Windows Server

Created by: Nate Oleson
Created date:
Last Updated date:

SYMPTOM

One or more of the following may apply:

  • Poor application performance overall (not isolated to just one case)
  • Poor application performance immediately after performing a database schema upgrade.

CAUSE

In addition to running SQL maintenance (See KB) to address SQL index fragmentation, disk level fragmentation is also a significant factor in the performance of the SQL server.

RESOLUTION

  1. Launch Windows PowerShell as administrator (Right-click >> Run as Administrator)
  2. If your SQL data files were stored on the "E:\" volume, you can analyze disk fragmentation using the following command:

    optimize-volume E -analyze -verbose

  3. Based on the output from that command, if you determine that the volume is fragmented you can defragment using this PowerShell command:

    optimize-volume E
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk