Microsoft Download Center Archive

System Center Management Pack for Microsoft SQL Server 2012 Parallel Data Warehouse Appliance

  • Published:
  • Version: 1.0.14.0
  • Category: Tool
  • Language: English

This management pack provides capabilities to discover, monitor, and manage your SQL Server PDW appliances. The management pack simplifies the monitoring process for PDW.

  • This Management Pack for Microsoft SQL Server 2012 Parallel Data Warehouse (PDW) Appliance provides capabilities to discover, monitor, and manage your SQL Server 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, version 1.0.14.0

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

FileSHA1 HashSize
SQL2012PDWMP.msicce88d353b9151599f096591967bdd45e5798653628 KB
SQL2012PDW_MPGuide.docx6786ee39cbefb6184a69b54649067be22fe72992874 KB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

Operating Systems: Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012

    • Other Software:
      • System Center Operations Manager Operations Manager 2007 R2.
      • Microsoft SQL Server 2012 Parallel Data Warehouse (PDW) Appliance

Installation Instructions

  • Please refer to MP Guide.