Managing Microsoft SQL Servers › Microsoft SQL Server Objects

Microsoft SQL Server Objects

CA SRM captures information about the following Microsoft SQL server objects:

Servers

Statistics for free and occupied space and size, data space usage, index space usage, and date of last data collection

Databases

Statistics for free and occupied space and size, data space usage, transaction log usage, data files usage, files usage, and date of last data collection

File Groups

Statistics for free and occupied space and size, table usage, and date of last data collection

Tables

Statistics for free and occupied space and size, data space usage, index space usage, rows, system table, and date of last data collection

Data Files

Statistics for free and occupied space and size, file growth, location, and date of last data collection

Log Files

Statistics for file size and growth, and date of last data collection

Note: To help ensure that the Windows Client displays the most recent data collection, refresh open user views.