System Center Monitoring Pack for SQL Azure

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

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

Wizard to discover SQL Azure servers and databases
Provides connectivity status of SQL azure server.
Collects and monitor health of SQL azure 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
Highly optimized PowerShell based infrastructure to efficiently monitors SQL Azure.
Ability to define Custom thresholds for each monitor to configure the warning and critical alerts.
Run-as profile to securely Connect to SQL azure
Detailed knowledge to guide the IT OperaTor with troubleshooting the problem
Custom tasks to redirect the user to the SQL azure online portal

Requirements

- System Center Operations Manager Operations Manager 2007 R2 CU4 or newer.
- SQL Azure Subscription