Microsoft SQL Server 2008 Analysis Services (Monitoring)

Microsoft.SQLServer.2008.AnalysisServices.Monitoring :: 7.0.17.0 (Management Pack)

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

Summary

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

Management Pack Elements

Show Management Pack References

TypeDefinitions

ModuleTypes

ConditionDetectionModuleType (1)
DataSourceModuleType (9)
ProbeActionModuleType (8)
WriteActionModuleType (1)

UnitMonitorType (12)

Monitoring

Monitors

DependencyMonitor (2)
UnitMonitor (13)

Rule (47)
Task (2)

Resources

DeployableAssembly (1)

ConditionDetection Modules (1)

	DisplayName	ID	Isolation	Accessibility
	Property Bag Performance Data Mapper	Microsoft.SQLServer.2008.AnalysisServices.ConditionDetection.PropertyBagPerformanceDataMapper	Any	Internal

DataSource Modules (9)

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

ProbeAction Modules (8)

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

WriteAction Modules (1)

	DisplayName	ID	Isolation	Accessibility
	SSAS 2008: Windows Service Control	Microsoft.SQLServer.2008.AnalysisServices.WriteAction.ServiceControl	Any	Internal

Unit Monitor Types (12)

DisplayName	ID	Accessibility	Support Monitor Recalculate
Blocking Session Count monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Database.BlockedSessionsNumber	Internal	False
Blocking Duration monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Database.BlockingDuration	Internal	False
Database Free Space monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Database.FreeSpacePercent	Internal	False
Memory Configuration Conflict with SQL Server monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Instance.ConfigurationConflictWithSQLServer	Internal	False
SQL 2008 AS: CPU Usage (\%) monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Instance.CpuUsage	Internal	False
Default Storage Free Space monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Instance.FreeSpacePercent	Internal	False
Memory Usage on the Server monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Instance.MemoryUsageByOtherProcessPercent	Internal	False
Memory Usage monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Instance.MemoryUsagePercent	Internal	False
Service State monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Instance.ServiceState	Internal	False
Total Memory Limit Configuration monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Instance.TotalMemoryConfiguration	Internal	False
Partition Storage Free Space monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Partition.FreeSpacePercent	Internal	False
Threads Performance Counter monitor type	Microsoft.SQLServer.2008.AnalysisServices.MonitorType.PerformanceCounterThreads	Internal	False

Dependency Monitors (2)

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

Unit Monitors (13)

DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
Memory Configuration Conflict with SQL Server	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.ConfigurationConflictWithSQLServer	Microsoft.SQLServer.2008.AnalysisServices.Instance	ConfigurationHealth	True	True	Public
CPU Utilization (\%)	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.CpuUsage	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Default Storage Free Space	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.FreeSpace	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Memory Usage	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.MemoryUsage	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Memory Usage on the Server	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.MemoryUsageByOtherProcess	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Processing Pool Job Queue length	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.ProcessingPoolJobQueueLength	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Query Pool Queue length	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.QueryPoolQueueLength	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceHealth	True	True	Public
Service State	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.ServiceState	Microsoft.SQLServer.2008.AnalysisServices.Instance	AvailabilityHealth	True	True	Public
Total Memory Limit Configuration	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.TotalMemoryConfiguration	Microsoft.SQLServer.2008.AnalysisServices.Instance	ConfigurationHealth	True	True	Public
Blocking Session Count	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.MultidimensionalDatabase.BlockedSessionsNumber	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceHealth	True	True	Public
Blocking Duration	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.MultidimensionalDatabase.BlockingDuration	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceHealth	True	True	Public
Database Free Space	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.MultidimensionalDatabase.FreeSpace	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceHealth	True	True	Public
Partition Storage Free Space	Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Partition.FreeSpace	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition	PerformanceHealth	True	True	Public

Rules (47)

DisplayName	ID	Target	Category	Enabled	Alert Generate
An error occurred during execution of a SSAS 2008 MP managed module	Microsoft.SQLServer.2008.AnalysisServices.AlertRule.Seed.ModuleError	Microsoft.SQLServer.2008.AnalysisServices.EventLogCollectionTarget	Alert	True	True
SSAS 2008: Actual System Cache (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ActualSystemCache	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Cache Evictions/sec	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.CacheEvictionsPerSec	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Cache Inserts/sec	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.CacheInsertsPerSec	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Cache added KB/sec	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.CacheKBAddedPerSec	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: CPU utilization (\%)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.CpuUsage	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Default Storage Folder Size (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.DefaultFolderSize	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Instance Free Space (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.FreeSpace	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Data Folder Available Space Ratio (\%)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.FreeSpacePercent	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Low Memory Limit (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.LowMemoryLimit	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: MDX Number of calculation covers	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MDXNumberCalculationCovers	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: MDX total cells calculated	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MDXTotalCellsCalculated	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: MDX Total NON EMPTY for calculated members	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MDXTotalNONEMPTYCalculatedMembers	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: MDX Total NON EMPTY unoptimized	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MDXTotalNONEMPTYUnoptimized	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: MDX Total Recomputes	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MDXTotalRecomputes	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: MDX Total Sonar subcubes	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MDXTotalSonarSubcubes	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Cleaner Current Price	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MemoryCostPerfomance	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Memory Usage on the Server (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MemoryUsageOnTheServer	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Memory Usage on the Server (\%)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MemoryUsageOnTheServerPercent	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Memory Usage by AS Non-shrinkable (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.NonShrinkableMemory	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Processing Aggreagations Rows created/sec	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ProcessingAggregationsRowsCreatedPerSec	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Indexes Processing Rows/sec	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ProcessingIndexesRowsPerSec	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Processing Pool Job Queue Length	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ProcessingPoolJobQueueLength	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Processing Rows read/sec	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ProcessingRowsReadPerSec	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Processing Rows written/sec	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ProcessingRowsWrittenPerSec	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Instance Memory (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ProcessTotalMemory	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Instance Memory (\%)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ProcessTotalMemoryPercent	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Query Pool Job Queue Length	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.QueryPoolQueueLength	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Storage Engine Query Rows sent/sec	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.StorageEngineQueryRowsSentPerSec	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Total Drive Size (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.TotalDriveSize	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Total Memory on the Server (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.TotalMemory	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Total Memory Limit (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.TotalMemoryLimit	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Used Space on Drive (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.UsedDriveSpace	Microsoft.SQLServer.2008.AnalysisServices.Instance	PerformanceCollection	True	False
SSAS 2008: Multidimensional Database Blocking Duration (minutes)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.BlockingDuration	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Multidimensional Database Disk Free Space (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.DiskFreeSpace	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Multidimensional Database Drive Space Used By Others (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.DriveSpaceUsedByOthers	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Multidimensional Database Free Space (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpace	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Multidimensional Database Free Space (\%)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpacePercent	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Number of Multidimensional Database Blocked Sessions	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.NumberOfBlockedSessions	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Multidimensional Database Storage Folder Size (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.StorageFolderSize	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Multidimensional DB Total Drive Size (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalDriveSize	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Multidimensional Database Size (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalSize	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Drive Used Space Multidimensional DB (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.UsedDriveSpace	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Partition Free Space (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalPartition.FreeSpace	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition	PerformanceCollection	True	False
SSAS 2008: Partition Free Space (\%)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalPartition.FreeSpacePercent	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition	PerformanceCollection	True	False
SSAS 2008: Partition Size (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalPartition.PartitionSize	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition	PerformanceCollection	True	False
SSAS 2008: Partition Used by Others (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalPartition.UsedByOthers	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition	PerformanceCollection	True	False

Agent Tasks (2)

	DisplayName	ID	Target	Accessibility	Category	Enabled
	Start SQL Server Analysis Services	Microsoft.SQLServer.2008.AnalysisServices.Task.Instance.StartService	Microsoft.SQLServer.2008.AnalysisServices.Instance	Internal	Maintenance	True
	Stop SQL Server Analysis Services	Microsoft.SQLServer.2008.AnalysisServices.Task.Instance.StopService	Microsoft.SQLServer.2008.AnalysisServices.Instance	Internal	Maintenance	True

Deployable Assemblies (1)

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