The System Center Monitoring Pack for Microsoft Data Warehouse (MDW) Appliance V2 provides capabilities to discover, monitor, and manage your SQL Server MDW appliances.
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
- 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 Guide: Microsoft Data Warehouse Appliance v2 Management Pack Guide