CloudMonix Support

New Features

Moderate - New BlockingQueries metric for SQL Azure databases. Metric tracks deadlocks by showing blocking and victim queries with associated query SQL as a collection-based metric

Moderate - New CurrentQueries metric for SQL Azure databases. Metric tracks currently executing queries and their associated SQL as a collection-based metric

Moderate - New Operations metric for v12+ SQL Azure databases. Metric tracks master-level database operations as a collection-based metric

Moderate - New WindowsPerformanceCounter and WindowsPerformanceCounterWIldcard metrics for v12+ SQL Azure database. Metric can track hundreds of SQL-based performance counters exposed thru Azure infrastructure

Moderate - Ability to execute Start and Stop commands for Azure Backup Vaults

Moderate - Status Dashboard - ability to enable/disable resources from the Status dashboard screen

Moderate - Resources Screen - ability to enable/disable resources from the Resource Management screen

Issues Resolved

Moderate - BlockingQueryCount numeric metric now works correctly for SQL Azure resources

Moderate - Manual Action execution icons no longer show up on the dashboard for resources that do not support any actions (ie: Azure Storage)

Moderate - Slight performance improvement for monitoring of Azure ARM-based resources

Minor - Manual Action dialog is now larger and no longer has scrollbars

1. Ensure that you dont add the Blocking Queries metric for monitored 'master' database, but individual monitored databases instead (as in, your SQL Azure monitored DB should not be master)

2. CurrentQueries metric needs to be checked with "Highlight on the dashboard" to show up in the dashboard

3. Performance counters: Probably monitoring master database again?

If these suggestions don't work, let's take it offline via support chat or support ticket

Scott,

We have a blog post on SQL Azure coming up, that will explain these metrics more in depth.  

Blocking Queries will track deadlocks (complete with "who is blocking who" information).

Current Queries metric will track currently executing queries (complete with SQL).  This maybe useful to capture for RCA reasons to help correlate alerts with currently executing queries.

Windows Performance Counters are metrics exposed by SQL Azure from its underlying servers.  I'm not sure how much information we have on them, but there is a ton of them.  More information is here about what these counters are: http://www.jasonstrate.com/2012/11/querying-performance-counters-in-sql-server/

Try adding new metrics, they make sense just by looking at their data.