Microsoft Data Warehouse Appliance v2 Management Pack (Monitoring)

Microsoft.SQLServerAppliance.MDW2.Monitoring :: 2.0.10.0 (Management Pack)

This Management Pack monitors all Microsoft Data Warehouse Appliance v2 instances.

• Show Management Pack XML
• Get Management Pack data in Excel format
• Download: Microsoft.SQLServerAppliance.MDW2.Monitoring.mp

Management Pack Elements

DataSource Modules (7)

	DisplayName	ID	Isolation	Accessibility
	MDW Appliance v2 SQL Server Lock Pages in Memory Provider	Microsoft.SQLServerAppliance.MDW2.DBEngineAllocatedPagesInMemoryProvider	Any	Internal
	MDW Appliance v2 SQL Server Startup Options Provider	Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOptionProvider	Any	Internal
	MDW Appliance v2 Service Account Data Source	Microsoft.SQLServerAppliance.MDW2.ServiceAccountDataSource	Any	Internal
	MDW Appliance v2 SQL Table Index Fragmentation Performance Data Source	Microsoft.SQLServerAppliance.MDW2.TableIndexFragmentationPerfType	Any	Internal
	MDW Appliance v2 SQL Table Index Fragmentation Data Source	Microsoft.SQLServerAppliance.MDW2.TableIndexFragmentationProvider	Any	Internal
	MDW Appliance v2 SQL Server tempdb Autogrowth Provider	Microsoft.SQLServerAppliance.MDW2.TempDBAutogrowthProvider	Any	Internal
	MDW Appliance v2 SQL Server tempdb Increment Step Provider	Microsoft.SQLServerAppliance.MDW2.TempDBIncrementStepProvider	Any	Internal

ProbeAction Modules (2)

	DisplayName	ID	Isolation	Accessibility
	High-Fragmented Tables Probe Action	Microsoft.SQLServerAppliance.MDW2.FragmentedIndexesProbe	Any	Internal
	Script Property Bag Probe Action	Microsoft.SQLServerAppliance.MDW2.ScriptPropertyBagProbeAction	Any	Internal

Unit Monitor Types (7)

	DisplayName	ID	Accessibility	Support Monitor Recalculate
	MDW Appliance v2 SQL Server Lock Pages in Memory Unit Monitor Type	Microsoft.SQLServerAppliance.MDW2.DBEngineAllocatedPagesInMemoryType	Internal	False
	MDW Appliance v2 SQL Server Startup Options	Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOption	Internal	False
	MDW Appliance v2 Service Account Monitor Type	Microsoft.SQLServerAppliance.MDW2.ServiceAccountMonitorType	Internal	False
	MDW Appliance v2 SQL Table Index Fragmentation Monitor Type	Microsoft.SQLServerAppliance.MDW2.TableIndexFragmentationType	Internal	False
	MDW Appliance v2 SQL Server tempdb Autogrowth Monitor Type	Microsoft.SQLServerAppliance.MDW2.TempDBAutogrowthType	Internal	False
	MDW Appliance v2 SQL Server tempdb Increment Step Monitor Type	Microsoft.SQLServerAppliance.MDW2.TempDBIncrementStepType	Internal	False
	MDW Appliance v2 Average Threshold Monitor	Microsoft.SQLServerAppliance.MDW2.ThreeStateAverageConsecutiveSamples	Internal	False

Aggregate Monitors (1)

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

Dependency Monitors (8)

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

Unit Monitors (9)

	DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
	MDW Appliance v2 Server Average CPU Performance Monitor	Microsoft.SQLServerAppliance.MDW2.AverageCPUPerformanceMonitor	Microsoft.SQLServerAppliance.MDW2.Server	PerformanceHealth	False	True	Public
	Lock Pages in Memory	Microsoft.SQLServerAppliance.MDW2.DBEngineAllocatedPagesInMemory	Microsoft.SQLServer.2012.DBEngine	ConfigurationHealth	False	True	Public
	Increase the Number of Extents in the Database	Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOptionE	Microsoft.SQLServerAppliance.MDW2.Server	ConfigurationHealth	True	True	Public
	Even growth DB files in filegroup	Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOptionT1117	Microsoft.SQLServerAppliance.MDW2.Server	ConfigurationHealth	True	True	Public
	SQL Server Agent service account monitor	Microsoft.SQLServerAppliance.MDW2.SQLServerAgentServiceAccountMonitor	Microsoft.SQLServerAppliance.MDW2.Server	ConfigurationHealth	True	True	Public
	SQL Server service account monitor	Microsoft.SQLServerAppliance.MDW2.SQLServerServiceAccountMonitor	Microsoft.SQLServerAppliance.MDW2.Server	ConfigurationHealth	True	True	Public
	Table Index Fragmentation	Microsoft.SQLServerAppliance.MDW2.TableIndexFragmentationMonitor	Microsoft.SQLServerAppliance.MDW2.Table	PerformanceHealth	True	True	Public
	Tempdb Autogrowth Monitor	Microsoft.SQLServerAppliance.MDW2.TempDBAutogrowthMonitor	Microsoft.SQLServerAppliance.MDW2.Server	ConfigurationHealth	True	False	Public
	Tempdb Increment Step Monitor	Microsoft.SQLServerAppliance.MDW2.TempDBIncrementStepMonitor	Microsoft.SQLServerAppliance.MDW2.Server	ConfigurationHealth	True	False	Public

Rules (1)

	DisplayName	ID	Target	Category	Enabled	Alert Generate
	MDW Appliance v2 SQL Table Index Fragmentation Performance Collection Rule	Microsoft.SQLServerAppliance.MDW2.TableIndexFragmentation.PerformanceCollectionRule	Microsoft.SQLServerAppliance.MDW2.Table	PerformanceCollection	True	False

Agent Tasks (1)

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

Monitor Property Overrides (1)

	ID	Context	Target
	Microsoft.SQLServerAppliance.MDW2.DBEngineAllocatedPagesInMemory.Override	Microsoft.SQLServerAppliance.MDW2.ServerGroup	Microsoft.SQLServerAppliance.MDW2.DBEngineAllocatedPagesInMemory