Home
  •  

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

DataSource Modules (6)

 DisplayNameIDIsolationAccessibility
Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemoryProviderMicrosoft Data Warehouse Appliance SQL Server Lock Pages in Memory ProviderMicrosoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemoryProviderAnyInternal
Microsoft.SQLServerAppliance.MDW.DBEngineStartupOptionProviderMicrosoft Data Warehouse Appliance SQL Server Startup Options ProviderMicrosoft.SQLServerAppliance.MDW.DBEngineStartupOptionProviderAnyInternal
Microsoft.SQLServerAppliance.MDW.IndexFragmentationProviderMicrosoft Data Warehouse Appliance SQL Server Extents Fragmentation ProviderMicrosoft.SQLServerAppliance.MDW.IndexFragmentationProviderAnyInternal
Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthProviderMicrosoft Data Warehouse Appliance SQL Server tempdb Autogrowth ProviderMicrosoft.SQLServerAppliance.MDW.TempDBAutogrowthProviderAnyInternal
Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepProviderMicrosoft Data Warehouse Appliance SQL Server tempdb Increment Step ProviderMicrosoft.SQLServerAppliance.MDW.TempDBIncrementStepProviderAnyInternal
Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelProviderMicrosoft Data Warehouse Appliance SQL Server tempdb Recovery Model ProviderMicrosoft.SQLServerAppliance.MDW.TempDBRecoveryModelProviderAnyInternal

ProbeAction Modules (2)

 DisplayNameIDIsolationAccessibility
Microsoft.SQLServerAppliance.MDW.FragmentedIndexesDiagnosticProbeHigh-Fragmented Tables Diagnostic Probe ActionMicrosoft.SQLServerAppliance.MDW.FragmentedIndexesDiagnosticProbeAnyInternal
Microsoft.SQLServerAppliance.MDW.FragmentedIndexesProbeHigh-Fragmented Tables Probe ActionMicrosoft.SQLServerAppliance.MDW.FragmentedIndexesProbeAnyInternal

Unit Monitor Types (6)

 DisplayNameIDAccessibilitySupport Monitor Recalculate
Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemoryTypeMicrosoft Data Warehouse Appliance SQL Server Lock Pages in Memory Unit Monitor TypeMicrosoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemoryTypeInternalFalse
Microsoft.SQLServerAppliance.MDW.DBEngineStartupOptionMicrosoft Data Warehouse Appliance SQL Server Startup OptionsMicrosoft.SQLServerAppliance.MDW.DBEngineStartupOptionInternalFalse
Microsoft.SQLServerAppliance.MDW.IndexFragmentationTypeMicrosoft Data Warehouse Appliance SQL Server Extents Fragmentation ProviderMicrosoft.SQLServerAppliance.MDW.IndexFragmentationTypeInternalFalse
Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthTypeMicrosoft Data Warehouse Appliance SQL Server tempdb Autogrowth Monitor TypeMicrosoft.SQLServerAppliance.MDW.TempDBAutogrowthTypeInternalFalse
Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepTypeMicrosoft Data Warehouse Appliance SQL Server tempdb Increment Step Monitor TypeMicrosoft.SQLServerAppliance.MDW.TempDBIncrementStepTypeInternalFalse
Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelTypeMicrosoft Data Warehouse Appliance SQL Server tempdb Recovery Model Monitor TypeMicrosoft.SQLServerAppliance.MDW.TempDBRecoveryModelTypeInternalFalse

Aggregate Monitors (1)

 DisplayNameIDTargetAlgorithmCategoryEnabledAlert GenerateAccessibility
Microsoft.SQLServerAppliance.MDW.TempDBConfigurationMicrosoft Data Warehouse Appliance Server tempdb Configuration RollupMicrosoft.SQLServerAppliance.MDW.TempDBConfigurationMicrosoft.SQLServerAppliance.MDW.ServerWorstOfConfigurationHealthTrueFalsePublic

Dependency Monitors (4)

 DisplayNameIDTargetAlgorithmSource MonitorRelationshipCategoryEnabledAlert GenerateAccessibility
Microsoft.SQLServerAppliance.MDW.Server.AvailabilityRollupMicrosoft Data Warehouse Appliance Server Availability RollupMicrosoft.SQLServerAppliance.MDW.Server.AvailabilityRollupMicrosoft.SQLServerAppliance.MDW.ApplianceWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServerAppliance.ApplianceContainsServerAvailabilityHealthTrueFalsePublic
Microsoft.SQLServerAppliance.MDW.Server.ConfigurationRollupMicrosoft Data Warehouse Appliance Server Configuration RollupMicrosoft.SQLServerAppliance.MDW.Server.ConfigurationRollupMicrosoft.SQLServerAppliance.MDW.ApplianceWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServerAppliance.ApplianceContainsServerConfigurationHealthTrueFalsePublic
Microsoft.SQLServerAppliance.MDW.Server.PerformanceRollupMicrosoft Data Warehouse Appliance Server Performance RollupMicrosoft.SQLServerAppliance.MDW.Server.PerformanceRollupMicrosoft.SQLServerAppliance.MDW.ApplianceWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServerAppliance.ApplianceContainsServerPerformanceCollectionTrueFalsePublic
Microsoft.SQLServerAppliance.MDW.Server.SecurityRollupMicrosoft Data Warehouse Appliance Server Security RollupMicrosoft.SQLServerAppliance.MDW.Server.SecurityRollupMicrosoft.SQLServerAppliance.MDW.ApplianceWorstOfSystem.Health.SecurityStateMicrosoft.SQLServerAppliance.ApplianceContainsServerSecurityHealthTrueFalsePublic

Unit Monitors (7)

 DisplayNameIDTargetCategoryEnabledAlert GenerateAccessibility
Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemoryLock Pages in MemoryMicrosoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemoryMicrosoft.SQLServer.2008.DBEngineConfigurationHealthFalseTruePublic
Microsoft.SQLServerAppliance.MDW.DBEngineStartupOptionEIncrease the Number of Extents in the DatabaseMicrosoft.SQLServerAppliance.MDW.DBEngineStartupOptionEMicrosoft.SQLServerAppliance.MDW.ServerConfigurationHealthTrueTruePublic
Microsoft.SQLServerAppliance.MDW.DBEngineStartupOptionT1117Even growth DB files in filegroupMicrosoft.SQLServerAppliance.MDW.DBEngineStartupOptionT1117Microsoft.SQLServerAppliance.MDW.ServerConfigurationHealthTrueTruePublic
Microsoft.SQLServerAppliance.MDW.IndexFragmentationExtent FragmentationMicrosoft.SQLServerAppliance.MDW.IndexFragmentationMicrosoft.SQLServer.2008.DatabasePerformanceHealthFalseTruePublic
Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthMonitorTempdb Autogrowth MonitorMicrosoft.SQLServerAppliance.MDW.TempDBAutogrowthMonitorMicrosoft.SQLServerAppliance.MDW.ServerConfigurationHealthTrueFalsePublic
Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepMonitorTempdb Increment Step MonitorMicrosoft.SQLServerAppliance.MDW.TempDBIncrementStepMonitorMicrosoft.SQLServerAppliance.MDW.ServerConfigurationHealthTrueFalsePublic
Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelMonitorTempdb Recovery Model MonitorMicrosoft.SQLServerAppliance.MDW.TempDBRecoveryModelMonitorMicrosoft.SQLServerAppliance.MDW.ServerConfigurationHealthTrueFalsePublic

Diagnostics (2)

 DisplayNameIDTargetMonitorCategoryEnabledAccessibility
Microsoft.SQLServerAppliance.MDW.ErrorFragmentedIndexesDiagnosticShow High-Fragmented TablesMicrosoft.SQLServerAppliance.MDW.ErrorFragmentedIndexesDiagnosticMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServerAppliance.MDW.IndexFragmentationOperationstrueInternal
Microsoft.SQLServerAppliance.MDW.WarningFragmentedIndexesDiagnosticShow Fragmented TablesMicrosoft.SQLServerAppliance.MDW.WarningFragmentedIndexesDiagnosticMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServerAppliance.MDW.IndexFragmentationOperationstrueInternal

Agent Tasks (1)

 DisplayNameIDTargetAccessibilityCategoryEnabled
Microsoft.SQLServerAppliance.MDW.FragmentedIndexesTaskShow High-Fragmented TablesMicrosoft.SQLServerAppliance.MDW.FragmentedIndexesTaskMicrosoft.SQLServer.2008.DatabasePublicOperationsTrue

Monitor Property Overrides (2)

 IDContextTarget
Microsoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemory.OverrideMicrosoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemory.OverrideMicrosoft.SQLServerAppliance.MDW.ServerGroupMicrosoft.SQLServerAppliance.MDW.DBEngineAllocatedPagesInMemory
Microsoft.SQLServerAppliance.MDW.IndexFragmentation.OverrideMicrosoft.SQLServerAppliance.MDW.IndexFragmentation.OverrideMicrosoft.SQLServerAppliance.MDW.ServerGroupMicrosoft.SQLServerAppliance.MDW.IndexFragmentation