Have you ever use the SQL server standard report? I believe most of the database admins are extensively using the reports on their daily work administrations. For those who doesn’t, please explore the reports which are really useful and resourceful.
So, how do we get the report? Launch the SQL server studio and login to your database. Right click on the database and go Reports > Standard Reports.
From the list above, you will able to execute the following SQL reports,
- Disk Usage
- Disk Usage by Top Tables
- Disk Usage by Table
- Disk Usage by Partition
- Backup and Restore Events
- All Transactions
- All Blocking Transactions
- Top Transaction by Age
- Top Transaction by Blocked Transaction Count
- Top Transactions by Locks Count
- Resource Locking Statistics by Objects
- Object Execution Statistics
- Database Consistency History
- Memory Usage by Memory Optimized Objects
- Index Usage Statistics
- Index Physical Statistics
- Schema Changes History
- User Statistics
Some examples from the report execution,
Disk Usage by Top Tables
The report provides detailed data on the utilization of disk space by top 1000 tables within the database.
Top Transactions by Age
This report identifies the oldest user transactions in the database.
Object Execution Statistics
This report provides detailed historical execution data for all currently cached plans for objects within the database. This execution data is aggregated over the time during which the plan been in the cache.
