Servers

System Center Management Pack for SQL Server 2012 Analysis Services

Language:
English
Monitoring Pack for SQL Server 2012 Analysis Services enables the monitoring of Instances, Databases and Partitions.
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
    Version:

    6.5.2.0

    File Name:

    Microsoft.SSAS.2012.ManagementPack.msi

    SSAS2012MPGuide.docx

    Date Published:

    4/11/2014

    File Size:

    896 KB

    1.2 MB

      The 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 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
      • New version of Generic Presentation Management Pack has been introduced
      • Summary dashboard for SQL Server Analysis Services 2012 Instances with drill-down to SQL Services Analysis Services 2012 Database dashboard
      • Summary dashboard for SQL Server Analysis Services 2012 Databases
      • Cross-version views
      • 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.
  • Supported Operating Systems:

    Windows Server 2008, Windows Server 2008 R2, Windows Server 2012

        • This monitoring pack requires System Center Operations Manager 2012 RTM or later. A dedicated Operations Manager management group is not required.
        • 64-bit SQL Server 2012 Analysis Services on 64-bit OS is supported.
        • x86 SQL Server 2012 Analysis Services on x86 OS is supported.
        • x86 SQL Server 2012 Analysis Services on 64-bit OS is not supported.
        • Low-privilege discovery and monitoring is not supported.
      Refer to the SQL Server 2012 Analysis Services management pack guide for more details.
    • For detailed instructions on setup, configuration and monitoring see the management pack guide

Popular Downloads

    • 01

      Microsoft® SQL Server® 2012 Express

      Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

    • 03

      Microsoft® SQL Server® 2008 Management Studio Express

      Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

    • 04

      Microsoft® SQL Server® 2014 Express

      Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

    • 05

      Microsoft Power Query for Excel

      Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

Loading your results, please wait...

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers