Microsoft Data Warehouse Appliance Management Pack (Monitoring)

Microsoft.SQLServerAppliance.MDW.Monitoring :: 1.0.10.0 (Management Pack)

This Management Pack monitors all Microsoft Data Warehouse Appliance instances.

Summary

The Microsoft Data Warehouse Appliance (Monitoring) Management Pack provides Microsoft Data Warehouse Appliance specific monitoring functionality. It requires SQL Server Appliance Core Library Management Pack.

Management Pack Elements

Show Management Pack References

TypeDefinitions

ModuleTypes

DataSourceModuleType (6)
ProbeActionModuleType (2)

UnitMonitorType (6)

Monitoring

Monitors

AggregateMonitor (1)
DependencyMonitor (4)
UnitMonitor (7)

Diagnostic (2)
Task (1)
Overrides

MonitorPropertyOverride (2)

DataSource Modules (6)

DisplayName	ID	Isolation	Accessibility
Microsoft Data Warehouse Appliance SQL Server Lock Pages in Memory Provider	Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemoryProvider	Any	Internal
Microsoft Data Warehouse Appliance SQL Server Startup Options Provider	Microsoft.SQLServerAppliance.MDW.DBEngineStartupOptionProvider	Any	Internal
Microsoft Data Warehouse Appliance SQL Server Extents Fragmentation Provider	Microsoft.SQLServerAppliance.MDW.IndexFragmentationProvider	Any	Internal
Microsoft Data Warehouse Appliance SQL Server tempdb Autogrowth Provider	Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthProvider	Any	Internal
Microsoft Data Warehouse Appliance SQL Server tempdb Increment Step Provider	Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepProvider	Any	Internal
Microsoft Data Warehouse Appliance SQL Server tempdb Recovery Model Provider	Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelProvider	Any	Internal

ProbeAction Modules (2)

	DisplayName	ID	Isolation	Accessibility
	High-Fragmented Tables Diagnostic Probe Action	Microsoft.SQLServerAppliance.MDW.FragmentedIndexesDiagnosticProbe	Any	Internal
	High-Fragmented Tables Probe Action	Microsoft.SQLServerAppliance.MDW.FragmentedIndexesProbe	Any	Internal

Unit Monitor Types (6)

DisplayName	ID	Accessibility	Support Monitor Recalculate
Microsoft Data Warehouse Appliance SQL Server Lock Pages in Memory Unit Monitor Type	Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemoryType	Internal	False
Microsoft Data Warehouse Appliance SQL Server Startup Options	Microsoft.SQLServerAppliance.MDW.DBEngineStartupOption	Internal	False
Microsoft Data Warehouse Appliance SQL Server Extents Fragmentation Provider	Microsoft.SQLServerAppliance.MDW.IndexFragmentationType	Internal	False
Microsoft Data Warehouse Appliance SQL Server tempdb Autogrowth Monitor Type	Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthType	Internal	False
Microsoft Data Warehouse Appliance SQL Server tempdb Increment Step Monitor Type	Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepType	Internal	False
Microsoft Data Warehouse Appliance SQL Server tempdb Recovery Model Monitor Type	Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelType	Internal	False

Aggregate Monitors (1)

	DisplayName	ID	Target	Algorithm	Category	Enabled	Alert Generate	Accessibility
	Microsoft Data Warehouse Appliance Server tempdb Configuration Rollup	Microsoft.SQLServerAppliance.MDW.TempDBConfiguration	Microsoft.SQLServerAppliance.MDW.Server	WorstOf	ConfigurationHealth	True	False	Public

Dependency Monitors (4)

DisplayName	ID	Target	Algorithm	Source Monitor	Relationship	Category	Enabled	Alert Generate	Accessibility
Microsoft Data Warehouse Appliance Server Availability Rollup	Microsoft.SQLServerAppliance.MDW.Server.AvailabilityRollup	Microsoft.SQLServerAppliance.MDW.Appliance	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServerAppliance.ApplianceContainsServer	AvailabilityHealth	True	False	Public
Microsoft Data Warehouse Appliance Server Configuration Rollup	Microsoft.SQLServerAppliance.MDW.Server.ConfigurationRollup	Microsoft.SQLServerAppliance.MDW.Appliance	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServerAppliance.ApplianceContainsServer	ConfigurationHealth	True	False	Public
Microsoft Data Warehouse Appliance Server Performance Rollup	Microsoft.SQLServerAppliance.MDW.Server.PerformanceRollup	Microsoft.SQLServerAppliance.MDW.Appliance	WorstOf	System.Health.PerformanceState	Microsoft.SQLServerAppliance.ApplianceContainsServer	PerformanceCollection	True	False	Public
Microsoft Data Warehouse Appliance Server Security Rollup	Microsoft.SQLServerAppliance.MDW.Server.SecurityRollup	Microsoft.SQLServerAppliance.MDW.Appliance	WorstOf	System.Health.SecurityState	Microsoft.SQLServerAppliance.ApplianceContainsServer	SecurityHealth	True	False	Public

Unit Monitors (7)

DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
Lock Pages in Memory	Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemory	Microsoft.SQLServer.2008.DBEngine	ConfigurationHealth	False	True	Public
Increase the Number of Extents in the Database	Microsoft.SQLServerAppliance.MDW.DBEngineStartupOptionE	Microsoft.SQLServerAppliance.MDW.Server	ConfigurationHealth	True	True	Public
Even growth DB files in filegroup	Microsoft.SQLServerAppliance.MDW.DBEngineStartupOptionT1117	Microsoft.SQLServerAppliance.MDW.Server	ConfigurationHealth	True	True	Public
Extent Fragmentation	Microsoft.SQLServerAppliance.MDW.IndexFragmentation	Microsoft.SQLServer.2008.Database	PerformanceHealth	False	True	Public
Tempdb Autogrowth Monitor	Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthMonitor	Microsoft.SQLServerAppliance.MDW.Server	ConfigurationHealth	True	False	Public
Tempdb Increment Step Monitor	Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepMonitor	Microsoft.SQLServerAppliance.MDW.Server	ConfigurationHealth	True	False	Public
Tempdb Recovery Model Monitor	Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelMonitor	Microsoft.SQLServerAppliance.MDW.Server	ConfigurationHealth	True	False	Public

Diagnostics (2)

	DisplayName	ID	Target	Monitor	Category	Enabled	Accessibility
	Show High-Fragmented Tables	Microsoft.SQLServerAppliance.MDW.ErrorFragmentedIndexesDiagnostic	Microsoft.SQLServer.2008.Database	Microsoft.SQLServerAppliance.MDW.IndexFragmentation	Operations	true	Internal
	Show Fragmented Tables	Microsoft.SQLServerAppliance.MDW.WarningFragmentedIndexesDiagnostic	Microsoft.SQLServer.2008.Database	Microsoft.SQLServerAppliance.MDW.IndexFragmentation	Operations	true	Internal

Agent Tasks (1)

	DisplayName	ID	Target	Accessibility	Category	Enabled
	Show High-Fragmented Tables	Microsoft.SQLServerAppliance.MDW.FragmentedIndexesTask	Microsoft.SQLServer.2008.Database	Public	Operations	True

Monitor Property Overrides (2)

	ID	Context	Target
	Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemory.Override	Microsoft.SQLServerAppliance.MDW.ServerGroup	Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemory
	Microsoft.SQLServerAppliance.MDW.IndexFragmentation.Override	Microsoft.SQLServerAppliance.MDW.ServerGroup	Microsoft.SQLServerAppliance.MDW.IndexFragmentation