The System Center Monitoring Pack for Microsoft Data Warehouse (MDW) Appliance V2 provides capabilities to discover, monitor, and manage your SQL Server MDW appliances.
Feature Summary
The following list gives an overview of the features of the MDW V2 Appliance management pack. Refer to the SQL Server MDW V2 Appliance Management Pack guide for more details.
- Discover MDW Appliance
- Dashboard view
- Monitor
- Tempdb increment step
- Tempdb Auto growth
- Tempdb recovery model
- Database fragmentation monitoring
- Table Index Fragmentation Monitoring
- Appliance Server CPU Monitoring
- SQL Server Service Account Monitoring
- SQL Server Agent Account Monitoring
- Lock pages
- SQL server startup options
- Run-as profile to securely connect to MDW appliance for discovery and monitoring.
Download the MP: System Center Monitoring Pack for Microsoft Data Warehouse Appliance V2
Download the MP Guide: Microsoft Data Warehouse Appliance v2 Management Pack Guide

Steve Gale: Just downloaded this. Can anyone tell me if the cache-clearing is supp...
Robert Wood: Ryan, you are saying the ping uses the FQDN?, because the only way it ...
Ryan Ephgrave: Are you talking about the WOL tool? I only check for the IP when I hav...
Robert Wood: Hi we have right click tools installed with SCCM 2012, I have noticed...
Garth Jones: Wow that is cool thanks!!...