System Center Management Packs for SQL Server 2008 & 2012 Analysis Services

The management packs for SQL Server Analysis Services 2008/2012 are now available to download from below links

 

 

The management packs deliver proactive and reactive monitoring capabilities for SQL Server Analysis Services (2008/2012) via System Center Operations Manager Management packs. These management pack includes extensive knowledge that enables near real-time diagnosis and resolution of issues.

System Center Operations Manager (SCOM) is a cross-platform data center management system that provides health and performance monitoring of systems and services. This management pack extends SCOM to include Analysis services monitoring capabilities.

These management packs offer the following benefits

• Simplified experience for discovery of Analysis Services Instances ( 2008 [Multidimensional, PowerPivot], 2012 [Multidimensional, PowerPivot, Tabular])

• Performance monitoring for Instances, Databases and Partitions

• Space monitoring for Instances, Databases and Partitions

• Extensive performance collection for memory, CPU and I/O utilization

• Ability to define custom thresholds for each monitor to configure warning and critical alerts

• Detailed knowledge to guide the IT operator in resolving problems

Rules and Monitors

 

Rules

Monitors

Actual System Cache (GB)

Blocking Duration

Cleaner Current Price

Blocking Session Count

Database Blocking Duration (minutes)

Database Free Space

Database Free Space (%)

Default Storage Free Space

Database Free Space (GB)

Memory Configuration Conflict with SQL Server

Database Size (GB)

Memory Usage

Database Storage Folder Size (GB)

Memory Usage on the Server

Default Storage Folder Size (GB)

Partition Storage Free Space

Drive Used Space (GB)

Processing Pool I/O Job Queue length

Instance Free Space (%)

Processing Pool Job Queue length

Instance Free Space (GB)

Query Pool Queue length

Instance Memory (GB)

Service State

Low Memory Limit (GB)

TotalMemoryLimit Configuration

Memory Usage by AS Non-shrinkable (GB)

Memory Usage on the Server (GB)

Partition Free Space (%)

Partition Free Space (GB)

Partition Size (GB)

Partition Used by Others (GB)

Processing Pool I/O Job Queue Length

Processing Pool Job Queue Length

Query Pool Job Queue Length

Number of Database Blocked Sessions

Total Drive Size (GB)

Total Memory Limit (GB)

Total Memory on the Server (GB)

SSAS 2008: Collect Used Space on Drive (GB)

Views and Dashboards

 

 Screenshots