The MS SQL Server Monitoring MP CTP2 - what's new?

Less than two months ago Microsoft released SQL Management Pack for Microsoft SQL Server 2016 Community Preview. Today, a new CTP version of that MP is available for download. Even though the interval between the releases was relatively short, that new CTP contains a number of valuable improvements.

The new release includes updates for many SQL Server versions:

  1. MS SQL 2005-2012
  2. MS SQL 2014
  3. MS SQL 2016 RC3

Dashboards MP was updated as well. We received a lot of valuable feedback regarding dashboard performance issues in the earlier release, and I can attest that now it performs much better even on the enterprise-size environments.

You can find a bunch of minor updates in SQL Dashboards that makes them more flexible and configurable.

Regarding other interesting updates in SQL MP, I want to highlight the following things:

  1. TLS v1.2 is now supported
  2. More AlwaysOn performance metrics are added
  3. Support for new SQL Server 2016 Memory-Optimized Data (previously known as In-Memory-OLTP) is now available
  4. Filestream Filegroup monitoring is supported

You can read about all updates, bug fixes, and improvements in more details in this MSDN blog post. We also recommend watching a demo recording by VIAcode System Center expert Alex Andruschenko.

Download the new MP, deploy it and provide your valuable feedback via Microsoft Connect. After all, the purpose of CTP is to hear the voice of our community. Rest assured, we take your advice and criticism very seriously, and, with your help, make the Management Packs and SQL Server better and more suitable to your needs.