SQL Server Drives


The SQL Server Drives page shows storage drive information for the SQL Server host. It helps DBAs identify disk capacity risks and storage pressure affecting database files.

Mini DBA SQL Server drives

What To Look For

  • Low free space.
  • Unusual drive growth.
  • Drives hosting data, log, tempdb, backup, or system files.
  • Storage issues that correlate with database file growth.

Workflow

  1. Open Drives for the SQL Server.
  2. Review free space and drive status.
  3. Open Files to see database file placement.
  4. Check Waits for I/O wait symptoms.
  5. Review alerts for capacity warnings.

How To Interpret SQL Server Drive Metrics

Drive metrics show host-level storage capacity and pressure for the SQL Server machine. Use this page when disk space alerts fire, database files grow, backups fail, or I/O waits increase. It helps connect SQL Server database files to the underlying drives that store them.

Start with low free space and rapid growth. Then compare the affected drive with SQL Server Files to identify which databases and file types are involved. If users report slowness at the same time, check SQL Server Waits for storage-related waits and SQL Server Activity for workload context.

Drive metrics depend on host visibility. If host OS login is not configured, some operating system storage counters may be unavailable. See Host OS Login for Windows and Linux host metric options, and Enable WMI For SQL Server Monitoring for Windows WMI permissions.

SQL Server Drives FAQ

Is low free space the only storage risk?

No. Latency, growth rate, file placement, backup location, and I/O waits can all indicate risk.

Why do database and drive sizes not match exactly?

SQL Server files, backups, operating system files, other applications, snapshots, and reserved space may all use the same drive.

What should I do before adding storage?

Identify which files are growing, why they are growing, and whether retention, backups, or workload changes explain the trend.

Related Pages