Table of contents
Collapse the table of content
Expand the table of content

Monitor the Appliance by Using System Center Operations Manager

Barbara Kess|Last Updated: 1/6/2017

This describes how to use System Center Operations Manager to monitor SQL Server PDW and HDInsight.

Before You Begin


  1. System Center Operations Manager 2007 R2, 2012, or 2012 SP1 must be installed and running.

  2. SQL Server 2008 R2 Native Client or SQL Server 2012 Native Client must be installed.

  3. The management packs to monitor SQL Server PDW and HDInsight must be installed, imported, and configured. Use the following for instructions to perform these tasks.

-   [Configure SCOM to Monitor Analytics Platform System (Analytics Platform System)](  

To Monitor SQL Server PDW with SCOM

After configuring the SCOM Management Packs, click on the Monitoring Pane of SCOM and drill down to SQL Server Appliance and then Microsoft SQL Server Parallel Data Warehouse. Underneath Microsoft SQL Server Parallel Data Warehouse, there are four choices: Alerts, Appliances, Appliance Diagram, and nodes.


Alerts are where you can find the current alerts to manage.



Appliances are where you will find the currently discovered and monitored SQL Server PDW Appliances in your environment. If an appliance does not show up here and you have created the ODBC connection for it, then there may be something wrong with your PDWWatcher account. If they show up as “Not monitored” there may be something wrong with your PDWMonitor account. Please be patient as SCOM does not make changes in real time, but periodically checks for new appliances to monitor and periodically sends queries to appliances for monitoring.


Appliances Diagram

The Appliances Diagram Page is where you can get a look at the health of your appliance with a tree view:

Appliances diagram


Finally, the Nodes view allows you to see the health of your appliance through each node:


See Also

Understanding Admin Console Alerts (Analytics Platform System)

© 2017 Microsoft