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

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index