| | DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
|---|
 | An error occurred during execution of a SSAS 2008 MP managed module | The rule oversees the Event Log and watches for error events submitted by SSAS 2008 management pack. If one of the workflows (discovery, rule or monitor) fails to do its job, an event is logged and a critical alert is reported. | Microsoft.SQLServer.2008.AnalysisServices.AlertRule.Seed.ModuleError | Microsoft.SQLServer.2008.AnalysisServices.Seed | Alert | True | | | 0 | 6200 | SSAS 2008 MP | True | Error | High | True | Operations Manager |
| SSAS 2008: Collect Actual System Cache (GB) | The rule collects the size in gigabytes of system cache on a computer where the SSAS instance is located. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ActualSystemCache | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Default Storage Folder Size (GB) | The rule collects the total size in gigabytes of the default storage folder (DataDir) for the SSAS instance. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.DefaultFolderSize | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Instance Free Space (GB) | The rule collects the amount of free space on the drive where the default storage folder (DataDir) for the SSAS instance is located in gigabytes. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.FreeSpace | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Instance Free Space (\%) | The rule collects the amount of free space on the drive where the default storage folder (DataDir) for the SSAS instance is located , expressed as percentage of the sum of estimated default storage folder (DataDir) size and disk free space. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.FreeSpacePercent | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Low Memory Limit (GB) | The rule collects the current configuration for the LowMemoryLimit of the SSAS instance in gigabytes. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.LowMemoryLimit | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Cleaner Current Price | The rule collects current price of memory as calculated by SSAS (cost per byte per unit of time) normalized and expressed on a scale of 0 to 1000. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MemoryCostPerfomance | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Memory Usage on the Server (GB) | The rule collects total memory usage in gigabytes on the server where the SSAS instance is located. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.MemoryUsageOnTheServer | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Memory Usage by AS Non-shrinkable (GB) | The rule collects non-shrinkable memory in gigabytes allocated by the SSAS instance. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.NonShrinkableMemory | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Processing Pool Job Queue Length | The rule collects the length of the processing pool job queue. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ProcessingPoolJobQueueLength | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Instance Memory (GB) | The rule collects the total size in gigabytes of memory allocated by the SSAS instance. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.ProcessTotalMemory | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Query Pool Job Queue Length | The rule collects the length of the query pool job queue. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.QueryPoolQueueLength | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Total Drive Size (GB) | The rule collects the total size in gigabytes of the drive where the default storage folder (DataDir) for the SSAS instance is located. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.TotalDriveSize | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Total Memory on the Server (GB) | The rule collects the total size of memory in gigabytes on the computer where the SSAS instance is running. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.TotalMemory | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Total Memory Limit (GB) | The rule collects the configuration on the SSAS instance for Total Memory Limit in gigabytes. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.TotalMemoryLimit | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Used Space on Drive (GB) | The rule collects the total amount of disk space in gigabytes used by the SSAS instance. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.Instance.UsedDriveSpace | Microsoft.SQLServer.2008.AnalysisServices.Instance | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Database Blocking Duration (minutes) | The rule collects the longest blocking duration for sessions that are currently blocked. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.BlockingDuration | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Database Free Space (GB) | The rule collects the amount of free space in gigabytes on the drive where the storage folder of the database is located. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpace | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Database Free Space (\%) | The rule collects the amount of free space on the drive where the storage folder of the database is located, expressed as percentage of the sum of estimated database storage folder size and disk free space. The rule does not take into account partitions located in folders other than the DB storage folder. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpacePercent | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect the Number of Database Blocked Sessions | The rule collects the number of sessions that are currently blocked. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.NumberOfBlockedSessions | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Database Storage Folder Size (GB) | The rule collects the estimated size of the database storage folder in gigabytes. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.StorageFolderSize | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Total Drive Size (GB) | The rule collects the total size in gigabytes of the drive where the database storage folder is located. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalDriveSize | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Database Size (GB) | The rule collects the total estimated database size in gigabytes including size of all partitions. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.TotalSize | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Drive Used Space (GB) | The rule collects the total size in gigabytes of all files and folders on the drive where the database storage folder is located. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.UsedDriveSpace | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Partition Free Space (GB) | The rule collects the amount of free space in gigabytes on the drive where the storage folder of the partition is located. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalPartition.FreeSpace | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Partition Free Space (\%) | The rule collects the size of free space on the drive where the partition storage is located, expressed as percentage of the sum of the partition storage folder total size plus disk free space. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalPartition.FreeSpacePercent | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Partition Size (GB) | The rule collects the estimated size of the partition in gigabytes. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalPartition.PartitionSize | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SSAS 2008: Collect Partition Used by Others (GB) | The rule collects the total amount of space in gigabytes on the drive where the storage folder of the partition is located, which is allocated by files and folders other than the storage folder of the partition. | Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalPartition.UsedByOthers | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
Home