Monitor the Appliance by Using System Center Operations Manager
This describes how to use System Center Operations Manager to monitor SQL Server PDW and HDInsight.
Before You Begin
System Center Operations Manager 2007 R2, 2012, or 2012 SP1 must be installed and running.
SQL Server 2008 R2 Native Client or SQL Server 2012 Native Client must be installed.
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)](configure-scom-to-monitor-analytics-platform-system.md)
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.
The Appliances Diagram Page is where you can get a look at the health of your appliance with a tree view:
Finally, the Nodes view allows you to see the health of your appliance through each node: