SCOM: SQL Server MP Community Technical Preview 1

A Community Technical Preview has been released for all of the SQL server versions and components they are available for download here. This MP is accompanied by a refresh of the SQL MPs released earlier this month v6.6.7.6, could this be an attempt to improve QA and testing on management pack releases, especially considering the issues with the SQL MP over the past year.

The new features and fixes introduced in CTP1 management packs are as follows:

    New Analysis Services 2016 MP Features and Fixes

    • Updated references and removed deprecated elements to support 6.6.4.0+ visualization library
    • Fixed bug when SSAS Monitoring Pack could not collect OS performance counters with localized names
    • Updated discoveries to throw errors in case of some problems detected during the discovery
    • Fixed module error collection on cluster instances to reduce the noise
    • Changed defaults for CPU Usage monitor, added sampling to Memory Usage on the server monitor
    • Reduced inner complexity of modules
    • Fixed the discoveries; now the last items can be undiscovered
    • Simplified the dashboard to make it quicker and more informative
    • Reviewed and updated the Knowledge Bases
    • Added timeout support for every non-native workflow
    • Fixed Blocking Session Monitor – in some situations it could calculate blocking sessions incorrectly
    • Win10 support: fixed OS version detection issue
    • Fixed CPU usage alert description
    • “Known Issues and Troubleshooting” section of the guide is updated

    New Reporting Services 2016 MP Features and Fixes

    • Fixed issue: Microsoft System Center Management Pack for SQL Server Reporting Services doesn’t discover SSRS instance when the instance name starts from some certain symbols (0-9, A-F)
    • Instance configuration monitor is introduced
    • Implemented a better logging system
    • Improved the Report Manager availability monitor: now it parses human readable message to get the real status of the Report Manager
    • Improved the Report Manager and Web Service availability monitors: now the user can treat some status codes as healthy via the override.
    • Fixed the discoveries, now the last items can be undiscovered
    • Added timeout support for every non-native workflow
    • Simplified the dashboard to make it quicker and more informative
    • Reviewed and updated the Knowledge Base articles
    • Improved Run As mappings
    • Updated the discoveries to throw errors in case of some problems detected during the discovery
    • Updated the references and removed deprecated elements to support 6.6.4.0+ visualization library
    • Changed the performance rules write actions accounts to “Default Action account”
    • “Known Issues and Release Notes” section of the guide is updated
    • Fixed “Memory consumed by other processes (%)” rule having no Run As profile for DS; added SQL MP default Run As to the data source
    • Fixed “Failing replacement: $Data/Context/Property[@Name='<MonitorName>’]$” issue in OM log

    New SQL Server 2005-2012 MP Features and Fixes

    • Fixed intermittent “Cannot login to database” alert with some rules
    • Added support for SQL Express Instances
    • Updated Knowledge Base articles
    • Microsoft SQL Server 2012 x86 on Windows 2008 R2: fixed the issue when DB file groups cannot be discovered
    • Win10 support: fixed “Cannot bind argument to parameter ‘Path’ because it is an empty string.” issue
    • Fixed issue when SQL Configuration Manager starts snap-in of wrong version
    • Fixed invalid Always On non-readable replica detection

    New SQL Server 2014-2016 MP Features and Fixes

    • Fixed intermittent “Cannot login to database” alert with some rules
    • Fixed display string for AgentsGroup.Discovery
    • Added support of SQL Server Express Instances
    • Always On issue: Events “967” are no longer fired for File Group and Files discoveries when server has a non-readable DB
    • DB Discovery issue fixed: masterDB is to be used if the target is inaccessible
    • DBSize issue: filter < 0 values in provider, return data for fileSize
    • Win10 support: fixed “Cannot bind argument to parameter ‘Path’ because it is an empty string.” issue
    • Agent Job Discovery is now disabled by default
    • Fixed issue when SQL Configuration Manager starts snap-in of wrong version
    • Fixed invalid Always On non-readable replica detection
    • Updated summary dashboards

2 thoughts on “SCOM: SQL Server MP Community Technical Preview 1

  1. Jim D

    I’m a little confused about the 6.6.7.6 SQL Server MPs you mentioned — I can’t find this version for SQL Server itself, either on the download site or the MP catalog. I downloaded the CTP and I see it includes the files; are they part of the CTP itself, or are they production-ready? (Assuming much testing first…)

    Reply
    1. Warren Kahn Post author

      Hi Jim,

      I believe the latest version of the SQL server MPs is 6.6.4.0, 6.6.7.6 only included the dashboards, SSAS and SSRS.

      The ones in the technical preview aren’t “live released” yet as I believe they want to do more testing with them.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.