SQL Server Reports
The following reports are available from the Reports Manager (Tools | Reports | Reports Manager).
DBA Reports| Report Name | Description |
|---|---|
| All jobs | Displays all scheduled SQL Server jobs and the job owner, organized by server. |
| Backup history | Displays the backup start date, type, and device used for the backup for a specified database for a set number of days. |
| Backup status | Displays the database name, date of the last backup, days since the last backup, and the type of backup performed. |
| Current lock report | Displays any locks on the server, including the database name, object or index name, type of lock, resource, mode, and status. |
| Database configuration options | Displays configuration options for each database on the specified server. |
| Database settings | Displays any common options and their values for all the databases on your server. |
| Database user details | Displays the user name, roles, objects, granted/denied status, and column permissions for each database. |
| Display errors | Displays a log file without entries for log backups. This is useful when you have a number of log backup entries and you need to locate non-backup errors. |
| Drive space usage | Displays space for all databases on the server, including free space, space used, maximum size, and growth type. |
| Foreign key sequence |
Displays tables in the order you can either populate or delete from them without violating any foreign key constraints. Objects with the lowest wave number indicate that they can be deleted with the fewest number of foreign key references. Objects with the highest wave number should be populated first. |
| Index description | (SQL Server 2000 only) Displays all indexes for the current database sorted by table. Index information includes whether it is clustered, unique, index keys, and the index size. run frequency, and the maximum duration. |
| Job details | (SQL Server 2000 only) Displays all SQL Server jobs, including whether they are scheduled, enabled, start date and time, |
| Row count for tables with clustered index | Displays the number of rows for all tables on a server that contain a clustered index. |
| Total rows and space used | Displays the total number of rows and space used for each table or view in the current database, including the reserved rows, unused rows, and index size. This report is sorted in descending order by reserved rows. |
| User permissions | Displays users permissions, grouped by role name and object type. |
| Report Name | Description |
|---|---|
| Configuration change history | Displays a history of all sp_configure and Trace Flag Changes recorded by the default trace. |
| Schema change history | Displays a history of all committed DDL statement executions recorded by the default trace. |
| Report Name | Description |
|---|---|
| Indexes | Displays index information for a selected table, including whether the index is clustered, unique, ignores duplicate keys, allows page/row locks, and a list of indexed columns. |
| Non-indexed tables | Displays any tables that have not been indexed for the selected database. |
| Table constraints | Displays any check constraints for a selected table, including whether the constraint is enabled, valid data, and affected columns. |
|
Table extended properties |
Displays any extended properties for a selected table. |
| Table relationships | Displays any foreign key constraints for a selected table, including whether the constraint is enabled, referenced tables, and referenced keys. |
| Tables and columns | Displays all columns for a selected table, including the data type, default value, whether it allows null values, and for SQL Server 2005 any extended properties. |
| Tables and indexes | Displays any indexes for a selected table, including the name, columns included in the index, and whether it is unique or clustered. |
| Report Name | Description |
|---|---|
| Stored procedures | Displays stored procedures for a selected database, including their status, status, replication information, schema version, statistics, and procedure text. |