mountainss Cloud and Datacenter Management Blog

Microsoft SystemCenter blogsite about virtualization on-premises and Cloud

Microsoft #SQL2012 reporting for System Center 2012 SP1 CTP VMM on Windows “8” Beta #SCVMM2012 #Windows8

Leave a comment


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.

Advertisements

Author: James van den Berg

I'm Microsoft Architect and ICT Specialist and Microsoft MVP System Center Cloud and Datacenter Management

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s