Determining managed storage capacity

You can track the capacity of managed storage assets. This information can be useful when you are calculating storage requirements for license renewal.

About this task

Typically, the capacity that is used by server data differs from the capacity of the volume that contains that data. For example, a set of databases might require a capacity of 1 GB and be on a 10 GB volume. When a snapshot of the volume is created, the Data Protection for SQL Server managed capacity measurement is 10 GB.

Procedure

  1. From Microsoft Management Console (MMC), select an SQL Server instance.
  2. On the Protect tab, click Properties in the Action pane.
  3. Select Managed Capacity from the list of available property pages. The managed capacity is calculated and displayed.
  4. To view a list of the volumes that contain backups and their respective managed capacities, click Show Details.