Skip to content

SCOM Monitoring Pack for SQL PDW

2012 February 13
by Brian Mitchell

A while back, we released the System Center Operations Manager Monitoring Pack for SQL Server 2008 R2 Parallel Data Warehouse Appliance (SCOM MP for SQL Server SystemCenterOpsManager_rgb_365x50PDW).  Last month was my first chance to really get my hands on it and found it to be intuitive and easy to use, if not to install and configure.   Once and organization has installed and configured the SCOM MP for SQL Server PDW they will improve their ability to be proactive about monitoring the basic configuration and health of the appliance.

One the nice aspects of the SCOM MP for SQL Server PDW is that once you have set up the run-as accounts to securely access your PDW appliance, adding another appliance forSQL08R2-PDW_h_rgb monitoring is as easy as setting up an additional ODBC connection to PDW on the SCOM Server.  SCOM will automatically discover the connection and then add the appliance to the list of appliances monitored.  You do not have to install any agents on your PDW appliance, all monitoring is done through queries from the SCOM server to the PDW Control Node where it uses the same DMVs for monitoring that you or the Administrators console would use. 

At its most base level, the SCOM MP for SQL Server PDW allows organizations the ability to see in one place alerts from all PDW appliances that they are monitoring.  With this MP you can monitor the warnings and critical alerts generated for things such as free space, service state, hard drive failures, plus many more.  Administrators can set up SCOM to send emails to a group of administrators whenever these alerts are fired.

image

Click on any of the above alerts to get additional details about the alert such as what you see below including Summary, Causes, and Resolutions.  This is a great starting point to help diagnose the issue and build organizational knowledge about how to resolve any issues you might encounter with SQL Server PDW.

Alert-Details

The Nodes view allows an Administrator to see the health of all the PDW appliance nodes in the same basic view that the admin console gives.   The biggest difference is the ability to see the state of all nodes from all appliances an organization owns in one view.  By using the filter box at the top of the view, you can narrow nodes down by appliance name or state.

SCOM-Nodes

The Appliance Diagram view is an intuitive way to be able to drill down into an appliance to show state.  I personally prefer the nodes view as I can ascertain the same information about more nodes and services much more quickly.  Here you can see that I am monitoring two appliances and the one on the left is providing me with a warning.

ApplianceDiagram-TopLevel

I can drill into the appliance all the way down to the spare node of the first data rack to find out that it has a volume free space warning.  The second data rack and landing zones also have warnings I need to check out.  While this is pretty, I could have ascertained all of this from the Nodes view shown previously.

 

ApplianceDiagram-Expanded

I’ll do a separate post sometime soon about the process of installing the SCOM MP for SQL Server PDW as that has some gotches.  In the meantime, if you have a need to check it out please download the management pack here:  Monitoring Pack for SQL Server Parallel Data Warehouse Appliance.  You will first need to install the SQL Server Appliance Base Management Pack

No comments yet

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS