SQL Server Parallel Data Warehouse Appliance
System Center Management Pack for Microsoft SQL Server 2008 R2 / 2012 Parallel Data Warehouse Appliance
This management pack provides capabilities to discover, monitor, and manage your SQL Server PDW appliances. The management pack simplifies the monitoring process for PDW.
Read More...
This Management Pack for Microsoft SQL Server Parallel Data Warehouse (PDW) Appliance provides capabilities to discover, monitor, and manage your SQL Server 2008 R2/ 2012 PDW appliances. The management pack simplifies the monitoring process for PDW. This version of management packs has also added monitoring for the new components that are added in PDW 2012.
In addition to health monitoring capabilities, this monitoring pack includes a custom diagram view to visualize appliance health. The custom view has detailed knowledge about the health states for the hardware and software components. The custom view enables near real-time diagnosis and resolution of detected issues.
Important Pre-Requisite Notes:
This management pack depends on the SQL Server Appliance Base Monitoring Pack; this helps you manage your SQL Server appliances by discovering appliances in your network and distinguishing them from other Windows servers.
You need to import the SQL Server Base Appliance Management Pack before importing the SQL Server PDW Appliance Management Pack. You can download the SQL Server Appliance Base Management Pack here
Feature Summary
The following list gives an overview of the features of this management pack for PDW Appliance. Refer to the Management Pack for SQL Server 2012 PDW Appliance guide for more details.
- Discovers SQL Server PDW Appliances, including the hardware manufacturer.
- Monitors both hardware and software components of SQL Server PDW Appliance. This includes:
- The ability to roll up the overall health information across hardware and software components.
- The ability to detect and monitor nodes that belong to different SQL Server PDW failover clusters.
- Custom diagram view to visually represent the PDW appliance hierarchy comprising of hardware and software components. This includes these three views:
- Appliance view – high level health information of the overall appliance health and their individual nodes
- Appliance nodes – view to represent the health of each of the nodes and their roles.
- Alerts view –view for the IT operator to look at proactive monitoring alerts and take appropriate actions.
- Custom e-mail template to provide more detailed information regarding the alerts.
- Tasks to integrate with the various PDW admin console views.
- Run-as profile to securely connect to PDW appliance for discovery and monitoring.
Release History
- 4/8/2013 - Original Release for PDW 2012, version 1.0.14.0
- 1/31/2012 - Updated release, version 1.0.774.0, with following fixes:
- Discovery of PDW appliance for AU3 updated without dwsys database
- Discovery for AU3 appliance nodes due to casing changes in dm_pdw_nodes.type column
- 9/27/2011 - Original Release for PDW 2008 R2, version 1.0.756.0
Elements
- TypeDefinitions
- Categories
- Monitoring
- Presentation
- Resources
Home