Data Warehouse Appliance
The System Center Monitoring Pack for Microsoft Data Warehouse (MDW) Appliance provides capabilities to discover, monitor, and manage your SQL Server MDW appliances.
Read More...
The System Center Monitoring Pack for Microsoft Data Warehouse (MDW) Appliance provides capabilities to discover, monitor, and manage your SQL Server MDW appliances. The custom view enables near real-time diagnosis and resolution of detected issues.
Important Pre-Requisite Notes:
The Following Management Packs must be imported and configured on Operations Manager Root Management server before the Data Warehouse Appliance Management Pack import:
- SQL Server Appliance Library 1.0.3.0 - You can download the SQL Server Appliance Base Management Pack here
- System Center Operations Manager 2007 R2 version 6.1.7221.0
- Windows Server 2008 version 6.0.6794.0
- Microsoft SQL Server 2008 version 6.1.400.0
Feature Summary
The following list gives an overview of the features of the MDW Appliance management pack. Refer to the SQL Server MDW 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
- Lock pages
- SQL server startup options
- Run-as profile to securely connect to MDW appliance for discovery and monitoring.
Elements
- TypeDefinitions
- Monitoring
- Presentation
- Resources
Home