BI performance counter: % Free Space

Applies to

Operating System

Description

Returns the percentage of available free space per volume. Make sure this is not too low otherwise the database may run out of space to grow. As a rough guide aim to keep 20% free space per volume.

Resolved by

DBAs

Suggested solutions

  1. Expand storage capacity of volume
  2. Create additional database files onto another volume
  3. Remove any unnecessary files from the volume (old logs and backups; setup files, documents, etc.)
  4. If backing up to disk, make sure compression is used
  5. Enable data page compression if CPU usage doesn’t suffer

See more

Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device

 

⇐ Back to index