mountainss Cloud and Datacenter Management Blog

Microsoft SystemCenter blogsite about virtualization on-premises and Cloud

#Microsoft #WindowsAzure #SQL Database Management Pack for System Center 2012 #sysctr

5 Comments


SCOM WindowsAzure

Overview

The Microsoft Windows Azure SQL Database Management Pack enables you to monitor the availability and performance of applications that are running on Windows Azure SQL Database.
Feature Summary After configuration, the Microsoft Windows Azure SQL Database Monitoring Management Pack offers the following functionalities:

  • User-friendly wizard to discover Windows Azure SQL Database servers.
  • Provides availability status of Windows Azure SQL Database server.
  • Collects and monitors health of Windows Azure SQL Database databases.
    • Space monitoring:
      • Used space
      • Free space
      • Total allocated quota
    • Track the total number of databases per server
  • 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
  • Ability to define Custom thresholds for each monitor to configure the warning and critical alerts.
  • Run-as profile to securely connect to Windows Azure SQL Database.
  • Detailed knowledge to guide the IT operator with troubleshooting the problem
  • Custom tasks to redirect the user to the Windows Azure SQL Database online portal
  • Custom query support to enable application-specific availability and performance monitoring

You can download the Microsoft Windows Azure SQL Database Management Pack here

Advertisements

Author: James van den Berg

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

5 thoughts on “#Microsoft #WindowsAzure #SQL Database Management Pack for System Center 2012 #sysctr

  1. Pingback: Implementing System Center Management Pack for #WindowsAzure SQL Database Monitoring #sysctr | mountainss SystemCenter Blog

  2. Pingback: Microsoft Most Valuable Professional (MVP) – Best Posts of the Week around Windows Server, Exchange, SystemCenter and more – #28 - Flo's Datacenter Report

  3. Pingback: Microsoft Most Valuable Professional (MVP) – Best Posts of the Week around Windows Server, Exchange, SystemCenter and more – #28 - TechCenter - Blog - TechCenter – Dell Community

  4. Pingback: Server King » Dell’s Digest for May 13, 2013

  5. Pingback: Microsoft Most Valuable Professional (MVP) – Best Posts of the Week around Windows Server, Exchange, SystemCenter and more – #29 - Flo's Datacenter Report

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