mountainss Cloud and Datacenter Management Blog

Microsoft SystemCenter blogsite about virtualization on-premises and Cloud

Microsoft #Azure #SQL Database Management Pack for #Sysctr 2012

Leave a comment


AzureSQL MP Diagram

This diagram shows the classes used or defined in the management pack

The Microsoft Azure SQL Database Management Pack enables you to monitor the availability and performance of applications that are running on Microsoft Azure SQL Database.

Feature Summary
After configuration, the Microsoft Azure SQL Database Monitoring Management Pack offers the following functionalities:

  • User-friendly wizard to discover Microsoft Azure SQL Database servers.
  • Provides availability status of Microsoft Azure SQL Database server.
  • Collects and monitors health of Microsoft Azure SQL Database databases.
    • Space monitoring:
      • Used space
      • Free space
      • Total allocated quota
    • Track the total number of databases per server
    • Successful connections count
    • Failed connections count
    • Number of deadlocks
    • Throttling/long transactions count
    • Connections blocked by firewall count
  • Collects and monitors performance information:
    • Average memory per session
    • Total memory per session
    • Total CPU time per session
    • Total I/O per session
    • Number of database sessions
    • Maximum Transaction execution time
    • Maximum Transaction lock count
    • Maximum Transaction log space used
    • Network Egress/Ingress bandwidth
    • Percentage of CPU used
    • Percentage of workers used
    • Percentage of CPU used
  • Ability to define Custom thresholds for each monitor to configure the warning and critical alerts.
  • Run-as profile to securely connect to Microsoft Azure SQL Database.
  • Detailed knowledge to guide the IT operator with troubleshooting the problem.
  • Custom tasks to redirect the user to the Microsoft Azure SQL Database online portal.
  • Custom query support to enable application-specific availability and performance monitoring.
  • Dashboard functionality

You can download the Microsoft Azure SQL Database Management Pack for System Center 2012 here

SCOM Azure SQL

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