This topic is about reporting SQL 2012 for System Center 2012 SP1 CTP Virtual Machine Manager under Windows “8” Beta Server.
If you open Microsoft SQL 2012 Management Studio and go to the Virtual Machine Manager (VMM) database :
Here you can make the following standard reports by SQL 2012 Server about Virtual Machine Manager :
- 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 Transactions by Age
- Top Transactions by Blocked Transactions Count
- Top Transactions by locks Count
- Resource locking statistics by Objects
- Obeject Execution Statistics
- Database Consistency History
- Index Usage Statistics
- Index Physical Statistics
- Schema Changes History
- User Statistics
Here are some examples of the reports you can run with SQL 2012 Management Studio :
This is a report on the disk Usage of the VMM Database running on Windows “8” Server Beta with SQL 2012.
Here you see the User Statistics of System Center Virtual Machine Manager.
Here you see the Usage by Partion of the SQL DataBase of SCVMM.
When you don’t have Microsoft System Center Operations Manager installed, standard reporting of SQL 2012 Server is handy to use.
You can also make your Custom report in SQL 2012 for SCVMM DataBase.