Microsoft SQL Server 2012 Analysis Services (Monitoring)

Microsoft.SQLServer.2012.AnalysisServices.Monitoring :: 1.0.5.0 (Management Pack)

Microsoft SQL Server 2012 Analysis Services Management Pack. This management pack monitors Microsoft SQL Server 2012 Analysis Services.

Summary

Microsoft SQL Server 2012 Analysis Services (Monitoring) Management Pack provides Microsoft SQL Server 2012 Analysis Services specific monitoring functionality. It requires Microsoft SQL Server 2012 Analysis Services (Discovery) Management Pack.

Management Pack Elements

Show Management Pack References

TypeDefinitions

ModuleTypes

DataSourceModuleType (9)
ProbeActionModuleType (8)

UnitMonitorType (11)

Monitoring

Monitors

DependencyMonitor (3)
UnitMonitor (16)

Rule (37)

Resources

DeployableAssembly (1)

DataSource Modules (9)

DisplayName	ID	Isolation	Accessibility
Blocked Sessions Monitoring DataSource	Microsoft.SQLServer.2012.AnalysisServices.DataSource.BlockedSessions	Any	Internal
Database Space DataSource	Microsoft.SQLServer.2012.AnalysisServices.DataSource.DatabaseSpace	Any	Internal
Space Monitor DataSource	Microsoft.SQLServer.2012.AnalysisServices.DataSource.InstanceSpace	Any	Internal
Analysis Services Custom DataSource	Microsoft.SQLServer.2012.AnalysisServices.DataSource.MappedInstancePerfomanceDataProvider	Any	Internal
Performance Managed Custom DataSource	Microsoft.SQLServer.2012.AnalysisServices.DataSource.MappedPerfomanceDataProvider	Any	Internal
Memory Monitor DataSource	Microsoft.SQLServer.2012.AnalysisServices.DataSource.MemoryUsage	Any	Internal
Multidimensional partition space counters data source	Microsoft.SQLServer.2012.AnalysisServices.DataSource.MultidimensionalPartitionSpace	Any	Internal
Analysis Services Custom Name DataSource	Microsoft.SQLServer.2012.AnalysisServices.DataSource.ScheduledInstancePerfomanceDataProvider	Any	Internal
Managed Custom DataSource	Microsoft.SQLServer.2012.AnalysisServices.DataSource.ScheduledPerfomanceDataProvider	Any	Internal

ProbeAction Modules (8)

DisplayName	ID	Isolation	Accessibility
Blocked Sessions Probe	Microsoft.SQLServer.2012.AnalysisServices.BlockedSessionsProbe	Any	Internal
Analysis Services Memory Monitor Probe	Microsoft.SQLServer.2012.AnalysisServices.Monitors.MemoryMonitorProbe	Any	Internal
Database Space Probe	Microsoft.SQLServer.2012.AnalysisServices.ProbeAction.DatabaseSpace	Any	Internal
Performance Counter Analysis Services Custom Name Probe	Microsoft.SQLServer.2012.AnalysisServices.ProbeAction.InstancePerfomanceDataProvider	Any	Internal
Space Monitor Probe	Microsoft.SQLServer.2012.AnalysisServices.ProbeAction.InstanceSpace	Any	Internal
Multidimensional partition space counters probe action	Microsoft.SQLServer.2012.AnalysisServices.ProbeAction.MultidimensionalPartitionSpace	Any	Internal
Performance Counter Managed Probe	Microsoft.SQLServer.2012.AnalysisServices.ProbeAction.PerfomanceDataProvider	Any	Internal
Verify Windows Service State	Microsoft.SQLServer.2012.AnalysisServices.VerifyWindowsServiceState	Any	Internal

Unit Monitor Types (11)

DisplayName	ID	Accessibility	Support Monitor Recalculate
Blocking Session Count monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Database.BlockedSessionsNumber	Internal	False
Blocking Duration monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Database.BlockingDuration	Internal	False
Database Free Space monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Database.FreeSpacePercent	Internal	False
Threads Performance Counter monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.CommonPerformanceData	Internal	False
Memory Configuration Conflict with SQL Server monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.ConfigurationConflictWithSQLServer	Internal	False
Default Storage Free Space monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.FreeSpacePercent	Internal	False
Memory Usage on the Server monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.MemoryUsageByOtherProcessPercent	Internal	False
Memory Usage monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.MemoryUsagePercent	Internal	False
Service State monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.ServiceState	Internal	False
TotalMemoryLimit Configuration monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Instance.TotalMemoryConfiguration	Internal	False
Partition Storage Free Space monitor type	Microsoft.SQLServer.2012.AnalysisServices.MonitorType.Partition.FreeSpacePercent	Internal	False

Dependency Monitors (3)

DisplayName	ID	Target	Algorithm	Source Monitor	Relationship	Category	Enabled	Alert Generate	Accessibility
Database Performance Rollup	Microsoft.SQLServer.2012.AnalysisServices.DependencyMonitor.MultidimensionalInstance.DatabasePerformanceRollup	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalInstance	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2012.AnalysisServices.Relationship.MultidimensionalInstanceHostsDatabase	PerformanceCollection	True	False	Public
Partitions Performance Rollup	Microsoft.SQLServer.2012.AnalysisServices.DependencyMonitor.MultidimensionalInstance.PartitionPerformanceRollup	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2012.AnalysisServices.Relationship.MultidimensionalDatabaseHostsPartition	PerformanceCollection	True	False	Public
Database Performance Rollup	Microsoft.SQLServer.2012.AnalysisServices.DependencyMonitor.TabularInstance.DatabasePerformanceRollup	Microsoft.SQLServer.2012.AnalysisServices.TabularInstance	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2012.AnalysisServices.Relationship.TabularInstanceHostsDatabase	PerformanceCollection	True	False	Public

Unit Monitors (16)

DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
Memory Configuration Conflict with SQL Server	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.ConfigurationConflictWithSQLServer	Microsoft.SQLServer.2012.AnalysisServices.Instance	ConfigurationHealth	True	True	Public
Default Storage Free Space	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.FreeSpace	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Memory Usage	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.MemoryUsage	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Memory Usage on the Server	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.MemoryUsageByOtherProcess	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Processing Pool I/O Job Queue length	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.ProcessingPoolIOJobQueueLength	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Processing Pool Job Queue length	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.ProcessingPoolJobQueueLength	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Query Pool Queue length	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.QueryPoolQueueLength	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Service State	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.ServiceState	Microsoft.SQLServer.2012.AnalysisServices.Instance	AvailabilityHealth	True	True	Public
TotalMemoryLimit Configuration	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Instance.TotalMemoryConfiguration	Microsoft.SQLServer.2012.AnalysisServices.Instance	ConfigurationHealth	True	True	Public
Blocking Session Count	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.MultidimensionalDatabase.BlockedSessionsNumber	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceHealth	True	True	Public
Blocking Duration	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.MultidimensionalDatabase.BlockingDuration	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceHealth	True	True	Public
Database Free Space	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.MultidimensionalDatabase.FreeSpace	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceHealth	True	True	Public
Partition Storage Free Space	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.Partition.FreeSpace	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalPartition	PerformanceHealth	True	True	Public
Blocking Session Count	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.TabularDatabase.BlockedSessionsNumber	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceHealth	True	True	Public
Blocking Duration	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.TabularDatabase.BlockingDuration	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceHealth	True	True	Public
Database Free Space	Microsoft.SQLServer.2012.AnalysisServices.UnitMonitor.TabularDatabase.FreeSpace	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceHealth	True	True	Public

Rules (37)

DisplayName	ID	Target	Category	Enabled	Alert Generate
An error occurred during execution of a SSAS 2012 MP managed module	Microsoft.SQLServer.2012.AnalysisServices.AlertRule.Seed.ModuleError	Microsoft.SQLServer.2012.AnalysisServices.Seed	Alert	True	True
SSAS 2012: Collect Actual System Cache (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.ActualSystemCache	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Default Storage Folder Size (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.DefaultFolderSize	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Instance Free Space (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.FreeSpace	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Instance Free Space (\%)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.FreeSpacePercent	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Low Memory Limit (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.LowMemoryLimit	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Cleaner Current Price	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.MemoryCostPerfomance	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Memory Usage on the Server (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.MemoryUsageOnTheServer	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Memory Usage by AS Non-shrinkable (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.NonShrinkableMemory	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Processing Pool I/O Job Queue Length	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.ProcessingPoolIOJobQueueLength	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Processing Pool Job Queue Length	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.ProcessingPoolJobQueueLength	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Instance Memory (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.ProcessTotalMemory	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Query Pool Job Queue Length	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.QueryPoolQueueLength	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Total Drive Size (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.TotalDriveSize	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Total Memory on the Server (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.TotalMemory	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Total Memory Limit (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.TotalMemoryLimit	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Used Space on Drive (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.Instance.UsedDriveSpace	Microsoft.SQLServer.2012.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2012: Collect Database Blocking Duration (minutes)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalDatabase.BlockingDuration	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Database Free Space (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpace	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Database Free Space (\%)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpacePercent	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2012: Collect the Number of Database Blocked Sessions	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalDatabase.NumberOfBlockedSessions	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Database Storage Folder Size (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalDatabase.StorageFolderSize	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Total Drive Size (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalDriveSize	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Database Size (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalSize	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Drive Used Space (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalDatabase.UsedDriveSpace	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Partition Free Space (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalPartition.FreeSpace	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalPartition	PerformanceCollection	True	False
SSAS 2012: Collect Partition Free Space (\%)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalPartition.FreeSpacePercent	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalPartition	PerformanceCollection	True	False
SSAS 2012: Collect Partition Size (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalPartition.PartitionSize	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalPartition	PerformanceCollection	True	False
SSAS 2012: Collect Partition Used by Others (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalPartition.UsedByOthers	Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalPartition	PerformanceCollection	True	False
SSAS 2012: Collect Database Blocking Duration (minutes)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.TabularDatabase.BlockingDuration	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Database Free Space (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.TabularDatabase.FreeSpace	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Database Free Space (\%)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.TabularDatabase.FreeSpacePercent	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceCollection	True	False
SSAS 2012: Collect the Number of Database Blocked Sessions	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.TabularDatabase.NumberOfBlockedSessions	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Database Storage Folder Size (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.TabularDatabase.StorageFolderSize	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Total Drive Size (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.TabularDatabase.TotalDriveSize	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Database Size (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.TabularDatabase.TotalSize	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceCollection	True	False
SSAS 2012: Collect Drive Used Space (GB)	Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.TabularDatabase.UsedDriveSpace	Microsoft.SQLServer.2012.AnalysisServices.TabularDatabase	PerformanceCollection	True	False

Deployable Assemblies (1)

	ID	File Name	Accessibility
	Microsoft.SQLServer.2012.AS.Monitoring.Assembly	Microsoft.SQLServer.2012.AS.Module.Monitoring.dll	Public