SRM SQL Server Reports

Topics | How To | Related Topics

SRM reports provide a sleek, versatile, and easy-to-use reporting framework that enables you to easily and effectively choose, view, and analyze vital data. Customized reporting is available through the selection of filter criteria (e.g., individual columns, specific clients, specific client computer groups, etc.) and filters as described in SRM Reports.

From the CommCell Console, the SRM Report Manager provides these types of reports:

Initial templates are provided for each type (e.g., Cost History by Application, Capacity by File System, etc.) where columns have been preselected. The only requirement before generating and displaying the report is to specify one or more client computers. For most reports, a data collection job must also have been run prior to generating the report.

Reports can be customized by adding or removing columns in the initial templates or specifying additional Filter Criteria.

This following table lists:

For step-by-step instructions on generating reports, see Display, Run, or Schedule a Report Manager Report for step-by-step instructions.

Category/Column  Description SRM SQL Agent
Discovery Job Discovery and Analysis Job
Client Properties Displays aspects of the client computer on which the SRM SQL Server Agent is installed.  
Hostname    
Memory    
Operating System    
OS Vendor    
OS Version    
Processors    
Service Pack    
SP Version    
Time Zone    
Database Capacity Displays space statistics of SQL databases and utilization %. Use to identify databases that are nearly full. You can set Actions for administrators to allocate more space for critical databases.  
Free Space  
Reserved Space  
Size Rank  
Used Space  
Utilization  
Database Details Displays properties of a database, such as creation date,  owner, status, and mode.  
Auto Shrink On  
Bulk Changed Extents  
Bulk Percent Change  
Collation  
Compatibility Level  
Create Status On  
Creation Date  
Detected Torn Pages  
Differential Extents  
Differential Percent Change  
Free Space  
Last Full Backup Date  
Last Log Backup Date  
Log File  
Owner  
Primary File  
Primary File Group  
Read-Write Mode  
Recovery Model  
Snapshot Isolation  
Status  
Total Extents  
Total Space  
Truncate Log On  
Type  
Update Status On  
Used Space  
User Mode  
Database Space Usage History Displays sum of space (used) for all databases, and utilization %. Use it to identify databases that are nearly full. You can set Actions for administrators to allocate more space for critical instances.  
As Of  
Free Space  
Total Space  
Used Space  
Utilization  
File Details Information about individual data and log files, such as instance, database, file group, location, and current capacity and utilization.  
Auto Growth    
Bulk Extents    
Differential Extents    
Free Space    
Group Default    
Log    
Maximum Size    
Path    
Reserved Space    
Size Rank    
Used Space    
Utilization    
File Group Capacity Displays space used by files in group and utilization % (size in use / size reserved). Use it to identify file groups that are nearly full. You can set Actions for administrators to allocate more space for critical file groups.  
Free Space  
Reserved Space  
Size Rank  
Used Space  
Utilization  
File Group Space Usage History Displays file group usage by used and free space and utilization % over time. Use the optional Predictive Trending feature to predict future growth patterns for capacity planning.  
As Of  
Free Space  
Total Space  
Used Space  
Utilization  
Index Details Display information about individual indexes, including fill factor % and space used.  
Average Bytes Free    
Average Pages    
Best Density    
Clustered    
Extents    
Fill Factor    
Forwarded Records    
Ignore Duplicates    
Levels    
Maximum Record Size    
Minimum Record Size    
Pad    
Pages    
Size Rank    
Total Records    
Unique    
Used Space    
Worst Density    
Index Space Usage History Displays index space usage by used space over time. Use the optional Predictive Trending feature to predict future growth patterns for capacity planning.  
As Of    
Used Space    
Server Capacity Displays space used by SQL servers and utilization %. Use it to identify servers that are nearly full. You can set Actions for administrators to allocate more space for critical servers.  
Free Space  
Reserved Space  
Used Space  
Utilization  
Server Details Displays properties of the SQL Server, such as, product name and version, maximum and minimum memory, and default collation order.  
Collation  
Databases  
Maximum Memory  
Minimum Memory  
Product  
Version  
Server Space Usage History Display space usage by SQL servers over time. Use the optional  Predictive Trending feature to predict future growth patterns for capacity planning.  
As Of  
Free Space  
Reserved Space  
Used Space  
Utilization  
SQL Database Disks    

Allocated Space

 Displays overall aspects per each disk selected.  
Block Size  
Blocks  
Capacity  
Disk  
Interface Type  
Manufacturer  
Model  
Partitions  
Serial Number  
Unallocated Space  
SQL Database Mirrors Displays aspect of Database Mirrors.  
Mirroring Partner  
Witness Partner  
SQL Database Snapshots Displays snapshots of the database.  
Compatibility Level  
Creation Date  
Last Full Backup Date  
Last Log Backup Date  
Read Write mode  
Recovery Mode  
Status  
Total Space  
Type  
Used Space  
User Mode  
SQL Entities Displays overall aspects per each computer selected (e.g., computer name, host group, etc.)  
Client Computer Group  
Computer  
SQL Server Instance  
Database  
File Group  
File Name  
Table  
Index  
Table Details Displays information about individual tables, including owner, rows, and size details.  
Clustered Index  
Data Size  
Index Size  
Owner  
Rows  
Size Rank  
Total Used Space  
Table Space Usage History Display table usage by used space over time. Use the optional  Predictive Trending feature to predict future growth patterns for capacity planning.  
As Of  
Data Size  
Index Size  
Rows  
Used Space  
User Space Usage Displays total space usage by user. Summarizes usage, highlighting the usage patterns of different users. Use this report to identify heavy disk consumers for capacity management and planning purposes.  
Name  
Total Free Space  
Total Reserved Space  
Total Used Space  
Usage Rank  
Utilization  

Back to Top