Microsoft SQL Server 2008 Analysis Services (Monitoring)

Microsoft.SQLServer.2008.AnalysisServices.Monitoring :: 6.6.0.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

DataSourceModuleType (9)
ProbeActionModuleType (8)

UnitMonitorType (12)

Monitoring

Monitors

DependencyMonitor (2)
UnitMonitor (13)

Rule (38)

Resources

DeployableAssembly (1)

DataSource Modules (9)

DisplayName	ID	Isolation	Accessibility
Blocked Sessions Monitoring DataSource	Microsoft.SQLServer.2008.AnalysisServices.DataSource.BlockedSessions	Any	Internal
Database Space DataSource	Microsoft.SQLServer.2008.AnalysisServices.DataSource.DatabaseSpace	Any	Internal
Space Monitor DataSource	Microsoft.SQLServer.2008.AnalysisServices.DataSource.InstanceSpace	Any	Internal
Analysis Services Custom DataSource	Microsoft.SQLServer.2008.AnalysisServices.DataSource.MappedInstancePerfomanceDataProvider	Any	Internal
Performance Managed Custom DataSource	Microsoft.SQLServer.2008.AnalysisServices.DataSource.MappedPerfomanceDataProvider	Any	Internal
Memory Monitor DataSource	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 DataSource	Microsoft.SQLServer.2008.AnalysisServices.DataSource.ScheduledInstancePerfomanceDataProvider	Any	Internal
Managed Custom DataSource	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

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
TotalMemoryLimit 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
TotalMemoryLimit 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 (38)

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.Seed	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 KB added/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: Instance Free Space (\%)	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: 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 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: 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: Database Blocking Duration (minutes)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.BlockingDuration	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Database Disk Free Space (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.DiskFreeSpace	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Database Drive Space Used By Others (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.DriveSpaceUsedByOthers	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Database Free Space (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpace	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Database Free Space (\%)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpacePercent	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: the Number of Database Blocked Sessions	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.NumberOfBlockedSessions	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Database Storage Folder Size (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.StorageFolderSize	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Total Drive Size (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalDriveSize	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Database Size (GB)	Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalSize	Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase	PerformanceCollection	True	False
SSAS 2008: Drive Used Space (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

Deployable Assemblies (1)

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