Query Managedcapacity command

Edit online

Use the Query Managedcapacity command to assist with storage planning by determining the amount of managed capacity in use.

Purpose

The query managedcapacity command displays capacity related information about the volumes that are represented in the local inventory, and are managed by Data Protection for SQL Server. This command is valid for all Windows™ operating systems that are supported by Data Protection for SQL Server.

: The capacity that is displayed includes deactivated backups, that is, backups which have not expired, on the IBM Storage® Protect server. Once a deleted backup has been expired by the IBM Storage Protect server, the capacity that is displayed no longer contains capacity for the deleted backup.

Figure 1. TDPSQLC command

Parameters

/DETAILED: Results in a detailed listing of snapped volumes. If this option is not specified then only the total capacity is displayed.

Example

Query the total managed capacity of SQL Server data represented in the local inventory with a detailed listing of snapped volumes:

tdpsqlc query managedcapacity /detailed

Total Managed Capacity : 63.99 GB (68,706,877,440 bytes)

Volume           : H:
Managed Capacity : 16.00 GB (17,176,719,360 bytes)

Volume           : I:
Managed Capacity : 16.00 GB (17,176,719,360 bytes)

Volume           : Q:
Managed Capacity : 16.00 GB (17,176,719,360 bytes)

Volume           : N:
Managed Capacity : 16.00 GB (17,176,719,360 bytes)