SQL Server Analysis Services

Monitoring Pack for SQL Server Analysis Services enables the monitoring of Instances, Databases and Partitions.

Versions

MP Version Release Date Comparison Description
6.7.15.0 for SQL Server 2012 Analysis Services 12/27/2016 6.6.7.6 for SQL Server 2012 Analysis Services
6.7.31.0 for SQL Server 2012 Analysis Services
6.6.0.0 for SQL Server 2012 Analysis Services
Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2012 Analysis Services. Please refer to the SQL Server 2012 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool I/O Job Queue length Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules New features Added support for configurations where computer host names are longer than 15 symbols Improvements: Updated the visualization library Fixes: Fixed: AS workflows sometimes crash
6.6.7.6 for SQL Server 2012 Analysis Services 3/28/2016 6.7.15.0 for SQL Server 2012 Analysis Services
6.7.31.0 for SQL Server 2012 Analysis Services
6.6.0.0 for SQL Server 2012 Analysis Services
Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2012 Analysis Services. Please refer to the SQL Server 2012 Analysis Services Management Pack Guide for more details. •SSAS Instance level monitoring •Service state •Memory Configuration Conflict with SQL Server •TotalMemoryLimit Configuration •Memory Usage •Memory Usage on the Server •Processing Pool I/O Job Queue length •Processing Pool Job Queue length •Query Pool Queue length •Default Storage Free Space •CPU utilization •SSAS Database level monitoring •Database Free Space •Blocking Duration •Blocking Session Count •SSAS Partition level monitoring •Partition Storage Free Space •A number of performance collection rules New features •Added timeout support for every non-native workflow Improvements: •Updated discoveries to throw errors in case of some problems detected during the discovery •Changed defaults for CPU Usage monitor, added sampling to Memory Usage on the server monitor •Simplified the dashboard to make it quicker and more informative •Reviewed and updated the Knowledge Bases Fixes: •Fixed the discoveries; now the last items can be undiscovered •Fixed module error collection on cluster instances to reduce the noise •Fixed bug when SSAS Monitoring Pack could not collect OS performance counters with localized names •Fixed CPU usage alert description •Fixed Blocking Session Monitor – in some situations it could calculate blocking sessions incorrectly •Win10 support: fixed OS version detection issue •Some other minor fixes Other changes: •Updated references and removed deprecated elements to support 6.6.4.0+ visualization library
6.7.31.0 for SQL Server 2012 Analysis Services 6/27/2017 6.7.15.0 for SQL Server 2012 Analysis Services
6.6.7.6 for SQL Server 2012 Analysis Services
6.6.0.0 for SQL Server 2012 Analysis Services
The Microsoft System Center Management Pack for SQL Server 2012 Analysis Services enables the discovery and monitoring of SQL Server 2012 Analysis Services Engines, Databases and Partitions. This Management Pack is designed to be run by Operations Manager 2012 RTM or higher. The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. In addition to health monitoring capabilities, this management pack includes dashboard views and extensive knowledge and views that enable near real-time diagnosis and resolution of detected issues. Note: If you are going to localize this management pack, keep in mind that localization installers on this page do not include files for localizing SQL Server Dashboards. Please use this link to download the required localization for Dashboards. Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2012 Analysis Services. Please refer to the SQL Server 2012 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool I/O Job Queue length Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules
1.0.5.0 for SQL Server 2008 Analysis Services 1/22/2014 There are no compatible versions available Monitoring Pack for SQL Server 2008 Analysis Services enables monitoring of the following features: Instance of SQL Server 2008 Analysis Services running in one of these modes: -Multidimensional Mode -PowerPivot Mode -SQL Server 2008 Analysis Services Databases -SQL Server 2008 Analysis Services Database Partitions The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge and views that enable near real-time diagnosis and resolution of detected issues.
6.6.0.0 for SQL Server 2008 Analysis Services 7/6/2015 6.6.7.6 for SQL Server 2008 Analysis Services
6.7.31.0 for SQL Server 2008 Analysis Service
6.7.15.0 for SQL Server 2008 Analysis Services
The Microsoft System Center Management Pack for SQL Server 2008 Analysis Services enables the discovery and monitoring of SQL Server 2008 Analysis Services Engines, Databases and Partitions. This Management Pack is designed to be run by Operations Manager 2012 RTM or higher. The monitoring provided by this management pack includes performance, availability and configuration scenarios, as well as performance data collection. All monitoring workflows have predefined thresholds and associated knowledge base articles. In addition to the health monitoring capabilities, this management pack includes dashboards, diagram, state, performance and alert views.
6.6.7.6 for SQL Server 2008 Analysis Services 3/28/2016 6.6.0.0 for SQL Server 2008 Analysis Services
6.7.31.0 for SQL Server 2008 Analysis Service
6.7.15.0 for SQL Server 2008 Analysis Services
Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2008 Analysis Services. Please refer to the SQL Server 2008 Analysis Services Management Pack Guide for more details. •SSAS Instance level monitoring •Service state •Memory Configuration Conflict with SQL Server •TotalMemoryLimit Configuration •Memory Usage •Memory Usage on the Server •Processing Pool Job Queue length •Query Pool Queue length •Default Storage Free Space •CPU utilization •SSAS Database level monitoring •Database Free Space •Blocking Duration •Blocking Session Count •SSAS Partition level monitoring •Partition Storage Free Space •A number of performance collection rules New features •Added timeout support for every non-native workflow Improvements: •Updated discoveries to throw errors in case of some problems detected during the discovery •Changed defaults for CPU Usage monitor, added sampling to Memory Usage on the server monitor •Simplified the dashboard to make it quicker and more informative •Reviewed and updated the Knowledge Bases Fixes: •Fixed the discoveries; now the last items can be undiscovered •Fixed module error collection on cluster instances to reduce the noise •Fixed bug when SSAS Monitoring Pack could not collect OS performance counters with localized names •Fixed CPU usage alert description •Fixed Blocking Session Monitor – in some situations it could calculate blocking sessions incorrectly •Win10 support: fixed OS version detection issue •Some other minor fixes Other changes: •Updated references and removed deprecated elements to support 6.6.4.0+ visualization library
6.6.0.0 for SQL Server 2012 Analysis Services 7/6/2015 6.7.15.0 for SQL Server 2012 Analysis Services
6.6.7.6 for SQL Server 2012 Analysis Services
6.7.31.0 for SQL Server 2012 Analysis Services
The Microsoft System Center Management Pack for SQL Server 2012 Analysis Services enables the discovery and monitoring of SQL Server 2012 Analysis Services Engines, Databases and Partitions. This Management Pack is designed to be run by Operations Manager 2012 RTM or higher. The monitoring provided by this management pack includes performance, availability and configuration scenarios, as well as performance data collection. All monitoring workflows have predefined thresholds and associated knowledge base articles. In addition to the health monitoring capabilities, this management pack includes dashboards, diagram, state, performance and alert views. Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2012 Analysis Services. Please refer to the SQL Server 2012 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool I/O Job Queue length Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules New features Dashboards were replaced with the new ones CPU utilization monitoring scenario on SSAS Instance level New performance collection rules are introduced: SSAS 2012: Database Disk Free Space (GB) SSAS 2012: Database Drive Space Used By Others (GB) SSAS 2012: Cache Evictions/sec SSAS 2012: Cache Inserts/sec SSAS 2012: Cache KB added/sec SSAS 2012: CPU utilization (%) SSAS 2012: Processing Rows read/sec SSAS 2012: Storage Engine Query Rows sent/sec Improvements: Icons for various classes are updated Performance counters object names are updated Fixes: An issue related to the discovery of a non-cluster instance on a cluster virtual node is fixed Some other minor fixes Other changes: Old dashboards are deprecated and removed Note: Microsoft SQL Server Analysis Services Visualization Library (version 1.0.5.0) has become obsolete and should be removed manually.
6.6.7.6 for SQL Server 2014 Analysis Services 3/28/2016 6.7.15.0 for SQL Server 2014 Analysis Services
6.7.31.0 for SQL Server 2014 Analysis Services
6.6.0.0 for SQL Server 2014 Analysis Services
Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2014 Analysis Services. Please refer to the SQL Server 2014 Analysis Services Management Pack Guide for more details. •SSAS Instance level monitoring •Service state •Memory Configuration Conflict with SQL Server •TotalMemoryLimit Configuration •Memory Usage •Memory Usage on the Server •Processing Pool I/O Job Queue length •Processing Pool Job Queue length •Query Pool Queue length •Default Storage Free Space •CPU utilization •SSAS Database level monitoring •Database Free Space •Blocking Duration •Blocking Session Count •SSAS Partition level monitoring •Partition Storage Free Space •A number of performance collection rules New features •Added timeout support for every non-native workflow Improvements: •Updated discoveries to throw errors in case of some problems detected during the discovery •Changed defaults for CPU Usage monitor, added sampling to Memory Usage on the server monitor •Simplified the dashboard to make it quicker and more informative •Reviewed and updated the Knowledge Bases Fixes: •Fixed the discoveries; now the last items can be undiscovered •Fixed module error collection on cluster instances to reduce the noise •Fixed bug when SSAS Monitoring Pack could not collect OS performance counters with localized names •Fixed CPU usage alert description •Fixed Blocking Session Monitor – in some situations it could calculate blocking sessions incorrectly •Win10 support: fixed OS version detection issue •Some other minor fixes Other changes: •Updated references and removed deprecated elements to support 6.6.4.0+ visualization library
6.7.15.0 for SQL Server 2016 Analysis Services 12/27/2016 6.7.31.0 for SQL Server 2016 Analysis Services
6.7.2.0 for SQL Server 2016 Analysis Services
The Microsoft System Center Management Pack for SQL Server 2016 Analysis Services enables the discovery and monitoring of SQL Server 2016 Analysis Services Engines, Databases and Partitions. This Management Pack is designed to be run by Operations Manager 2012 RTM or higher. The monitoring provided by this management pack includes performance, availability and configuration scenarios, as well as performance data collection. All monitoring workflows have predefined thresholds and associated knowledge base articles. In addition to the health monitoring capabilities, this management pack includes dashboards, diagram, state, performance and alert views. Note: If you are going to localize this management pack, keep in mind that localization installers on this page do not include files for localizing SQL Server Dashboards. Please use this link to download the required localization for Dashboards. Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2016 Analysis Services. Please refer to the SQL Server 2016 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool I/O Job Queue length Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules New features Added support for configurations where computer host names are longer than 15 symbols Improvements: Updated the visualization library Fixes: Fixed: AS workflows sometimes crash
6.7.31.0 for SQL Server 2008 Analysis Service 6/27/2017 6.6.0.0 for SQL Server 2008 Analysis Services
6.6.7.6 for SQL Server 2008 Analysis Services
6.7.15.0 for SQL Server 2008 Analysis Services
The Microsoft System Center Management Pack for SQL Server 2008 Analysis Services enables the discovery and monitoring of SQL Server 2008 Analysis Services Engines, Databases and Partitions. This Management Pack is designed to be run by Operations Manager 2012 RTM or higher. The monitoring provided by this management pack includes performance, availability and configuration scenarios, as well as performance data collection. All monitoring workflows have predefined thresholds and associated knowledge base articles. In addition to the health monitoring capabilities, this management pack includes dashboards, diagram, state, performance and alert views. Note: If you are going to localize this management pack, keep in mind that localization installers on this page do not include files for localizing SQL Server Dashboards. Please use this link to download the required localization for Dashboards. Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2008 Analysis Services. Please refer to the SQL Server 2008 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules
1.0.5.0 for SQL Server 2012 Analysis Services 1/22/2014 There are no compatible versions available Monitoring Pack for SQL Server 2012 Analysis Services enables monitoring of the following features: Instance of SQL Server 2012 Analysis Services running in one of these modes: -Multidimensional Mode -Tabular Mode -PowerPivot Mode -SQL Server 2012 Analysis Services Databases -SQL Server 2012 Analysis Services Database Partitions The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge and views that enable near real-time diagnosis and resolution of detected issues.
6.7.31.0 for SQL Server 2016 Analysis Services 6/27/2017 6.7.15.0 for SQL Server 2016 Analysis Services
6.7.2.0 for SQL Server 2016 Analysis Services
The Microsoft System Center Management Pack for SQL Server 2016 Analysis Services enables the discovery and monitoring of SQL Server 2016 Analysis Services Engines, Databases and Partitions. This Management Pack is designed to be run by Operations Manager 2012 RTM or higher. The monitoring provided by this management pack includes performance, availability and configuration scenarios, as well as performance data collection. All monitoring workflows have predefined thresholds and associated knowledge base articles. In addition to the health monitoring capabilities, this management pack includes dashboards, diagram, state, performance and alert views. Note: If you are going to localize this management pack, keep in mind that localization installers on this page do not include files for localizing SQL Server Dashboards. Please use this link to download the required localization for Dashboards. Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2016 Analysis Services. Please refer to the SQL Server 2016 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool I/O Job Queue length Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules
6.7.15.0 for SQL Server 2014 Analysis Services 12/27/2016 6.6.7.6 for SQL Server 2014 Analysis Services
6.7.31.0 for SQL Server 2014 Analysis Services
6.6.0.0 for SQL Server 2014 Analysis Services
Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2014 Analysis Services. Please refer to the SQL Server 2014 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool I/O Job Queue length Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules New features Added support for configurations where computer host names are longer than 15 symbols Improvements: Updated the visualization library Fixes: Fixed: AS workflows sometimes crash
6.7.2.0 for SQL Server 2016 Analysis Services 6/29/2016 6.7.15.0 for SQL Server 2016 Analysis Services
6.7.31.0 for SQL Server 2016 Analysis Services
The Microsoft System Center Management Pack for SQL Server 2016 Analysis Services enables the discovery and monitoring of SQL Server 2016 Analysis Services Engines, Databases and Partitions. This Management Pack is designed to be run by Operations Manager 2012 RTM or higher. The monitoring provided by this management pack includes performance, availability and configuration scenarios, as well as performance data collection. All monitoring workflows have predefined thresholds and associated knowledge base articles. In addition to the health monitoring capabilities, this management pack includes dashboards, diagram, state, performance and alert views. Note: If you are going to localize this management pack, keep in mind that localization installers on this page do not include files for localizing SQL Server Dashboards. Please use this link to download the required localization for Dashboards. Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2016 Analysis Services. Please refer to the SQL Server 2016 Analysis Services Management Pack Guide for more details. •SSAS Instance level monitoring •Service state •Memory Configuration Conflict with SQL Server •TotalMemoryLimit Configuration •Memory Usage •Memory Usage on the Server •Processing Pool I/O Job Queue length •Processing Pool Job Queue length •Query Pool Queue length •Default Storage Free Space •CPU utilization •SSAS Database level monitoring •Database Free Space •Blocking Duration •Blocking Session Count •SSAS Partition level monitoring •Partition Storage Free Space •A number of performance collection rules
6.7.15.0 for SQL Server 2008 Analysis Services 12/27/2016 6.6.0.0 for SQL Server 2008 Analysis Services
6.6.7.6 for SQL Server 2008 Analysis Services
6.7.31.0 for SQL Server 2008 Analysis Service
Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2008 Analysis Services. Please refer to the SQL Server 2008 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules New features Added support for configurations where computer host names are longer than 15 symbols Improvements: Updated the visualization library Fixes: Fixed: AS workflows sometimes crash Other changes: Updated references and removed deprecated elements to support 6.6.4.0+ visualization library
6.7.31.0 for SQL Server 2014 Analysis Services 6/27/2017 6.6.7.6 for SQL Server 2014 Analysis Services
6.7.15.0 for SQL Server 2014 Analysis Services
6.6.0.0 for SQL Server 2014 Analysis Services
The Microsoft System Center Management Pack for SQL Server 2014 Analysis Services enables the discovery and monitoring of SQL Server 2014 Analysis Services Engines, Databases and Partitions. This Management Pack is designed to be run by Operations Manager 2012 RTM or higher. The monitoring provided by this management pack includes performance, availability and configuration scenarios, as well as performance data collection. All monitoring workflows have predefined thresholds and associated knowledge base articles. In addition to the health monitoring capabilities, this management pack includes dashboards, diagram, state, performance and alert views. Note: If you are going to localize this management pack, keep in mind that localization installers on this page do not include files for localizing SQL Server Dashboards. Please use this link to download the required localization for Dashboards. Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2014 Analysis Services. Please refer to the SQL Server 2014 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool I/O Job Queue length Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules
6.6.0.0 for SQL Server 2014 Analysis Services 7/6/2015 6.6.7.6 for SQL Server 2014 Analysis Services
6.7.15.0 for SQL Server 2014 Analysis Services
6.7.31.0 for SQL Server 2014 Analysis Services
The Microsoft System Center Management Pack for SQL Server 2014 Analysis Services enables the discovery and monitoring of SQL Server 2014 Analysis Services Engines, Databases and Partitions. This Management Pack is designed to be run by Operations Manager 2012 RTM or higher. The monitoring provided by this management pack includes performance, availability and configuration scenarios, as well as performance data collection. All monitoring workflows have predefined thresholds and associated knowledge base articles. In addition to the health monitoring capabilities, this management pack includes dashboards, diagram, state, performance and alert views. Feature Summary The following list gives an overview of features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2014 Analysis Services. Please refer to the Microsoft SQL Server 2014 Analysis Services Management Pack Guide for more details. SSAS Instance level monitoring Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server Processing Pool I/O Job Queue length Processing Pool Job Queue length Query Pool Queue length Default Storage Free Space CPU utilization SSAS Database level monitoring Database Free Space Blocking Duration Blocking Session Count SSAS Partition level monitoring Partition Storage Free Space A number of performance collection rules New features in comparison with the previous release of SQL Server Analysis Services 2012 Management Pack Dashboards were replaced with the new ones CPU utilization monitoring scenario on SSAS Instance level New performance collection rules are introduced: SSAS 2014: Database Disk Free Space (GB) SSAS 2014: Database Drive Space Used By Others (GB) SSAS 2014: Cache Evictions/sec SSAS 2014: Cache Inserts/sec SSAS 2014: Cache KB added/sec SSAS 2014: CPU utilization (%) SSAS 2014: Processing Rows read/sec SSAS 2014: Storage Engine Query Rows sent/sec Improvements: Icons for various classes are updated Performance counters object names are updated Fixes: An issue related to the discovery of a non-cluster instance on a cluster virtual node is fixed Some other minor fixes Other changes: Old dashboards are deprecated and removed
AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED