Updated SQL Management Pack released with sweet new SQL Server 2012 Dashboard

 

Download: http://www.microsoft.com/en-us/download/details.aspx?id=10631

 

image

 

Changes in This Update

SQL Server Management Pack version 6.4.0.0 includes the following changes:

·        New Dashboard for SQL Server 2012 DB

·        New Monitors and Rules – only for SQL 2008 and SQL 2012

o   Collect DB Active Connections count

o   Collect DB Active Requests count

o   Collect DB Active Sessions count

o   Collect DB Active Transactions count

o   Collect DB Engine Thread count

o   Thread Count monitor

o   Transaction Log Free Space (%) monitor

o   Transaction Log Free Space (%) collection

o   Collect DB Engine CPU Utilization (%)

o   CPU Utilization (%)  monitor for DB engine

o   Buffer Cache Hit Ratio monitor

o   Collect DB Engine Page Life Expectancy (s)

o   Page Life Expectancy monitor

o   Collect DB Disk Read Latency (ms)

o   Collect DB Disk Write Latency (ms)

o   Disk Read Latency monitor

o   Disk Write Latency monitor

o   Collect DB Transactions per second count

o   Collect DB Engine Average Wait Time (ms)

o   Average Wait Time monitor

o   Collect DB Engine Stolen Server Memory (MB)

o   Stolen Server Memory monitor

o   Collect DB Allocated Free Space (MB)

o   Collect DB Used Space (MB)

o   Collect DB Disk Free Space (MB)

o   SQL Re-Compilation monitor

·        SPN monitor improved

·        Support for special symbols in DB names.

·        Improved AlwaysOn seed discovery

·        Run As configuration changes to support Low privilege for SQL Server 2012 Cluster

·        Improved performance of AlwaysOn discovery

·        Custom User Policy Discovery and Monitoring performance optimization

·        Hided AG health object from Diagram view

·        Minor changes

9 Responses to Updated SQL Management Pack released with sweet new SQL Server 2012 Dashboard

  1. Pieter Bovy September 9, 2013 at 7:02 am #

    Hi,

    we tried importing this MP in our SCOM 2012 RTM environment. However the SQL Presentation contains references to SCOM Core MP’s version 7.0.9538.0, which are part of the SCOM 2012 SP1 installation. Therefor I assume that the Microsoft Documentation on this MP is actually incorrect and the required SCOM version (at least for the Presentation MP, which contains these fancy dashboards) is actually at least SCOM 2012 SP1.

  2. Tim McFadden September 9, 2013 at 6:44 pm #

    Thanks for the feedback. A bug has been filed with the product team.

  3. Marc September 10, 2013 at 1:45 am #

    Did anyone install this MP´s sucessfully?
    In my Environment SCOM2012 SP1 UR2 only SQL Server Core Library and Visulaization Comonent Extensions Library in version 6.4 is imported.

    The other MP´s all show the following Massage:
    Found error in 1|Microsoft.SQLServer.2005.Discovery/31bf3856ad364e35|1.0.0.0|Microsoft.SQLServer.2005.ReportingServices|| with message:
    Could not load management pack [ID=Microsoft.SQLServer.Library, KeyToken=31bf3856ad364e35, Version=6.4.0.0]. The management pack was not found in the store.
    : Version mismatch. The management pack ([Microsoft.SQLServer.Library, 31bf3856ad364e35, 6.3.173.1]) requested from the database was version 6.4.0.0 but the actual version available is 6.3.173.1.

    Any ideas?

  4. David September 12, 2013 at 9:20 am #

    Hi there,

    After importing this MP, got the below alerts for many SQL servers. Is it bug in the SCOM MP?

    Operations Manager Failed to convert performance data

    Module was unable to convert parameter to a double value

    Original parameter: ‘$Data/Property[@Name=’CPUUsage’]$’

    Parameter after $Data replacement: ‘1.#INF’

    Error: 0x80020005

    Details: Type mismatch.

    One or more workflows were affected by this.

    Workflow name: Microsoft.SQLServer.2008.DBEngine.CPUUsagePercentMonitor

  5. Dan September 13, 2013 at 12:35 am #

    Seeing these errors on SQL 2012 since updating to 6.4

    Managegement Group:* . Script: Main :

    Method invocation failed because [System.Object[]] doesn’t contain a method named ‘op_Division’.Error occured during CPU Usage for SQL Instances data source executing.
    Computer:*
    Reason: Method invocation failed because [System.Object[]] doesn’t contain a method named ‘op_Division’.

  6. Tom September 16, 2013 at 12:45 pm #

    I’m seeing the same thing that Dan described. Very annoying because it’s filling up the log.

  7. Andrew C September 16, 2013 at 8:59 pm #

    I am seeing same as David in SCOM 2012 RTM for both Microsoft.SQLServer.2008.DBLogFile.FileAllocatedSpaceLeftPercent.Collection rule and Microsoft.SQLServer.2008.DBEngine.CPUUsagePercentMonitor monitor. I have disabled both MP objects until a fix found.

  8. Subramani October 2, 2013 at 7:39 am #

    You should disable the following rules:

    Disable the following rules:

    MSSQL 2012: Collect DB Engine CPU Utilization (%)

    MSSQL 2008: Collect DB Engine CPU Utilization (%)

    The following monitors:

    CPU Utilization (%) for 2008

    CPU Utilization (%) for 2012

Leave a Reply