mountainss Cloud and Datacenter Management Blog

Microsoft SystemCenter blogsite about virtualization on-premises and Cloud


Leave a comment

#Microsoft System Center Management Packs (CTP1) for #SQL Server #Sysctr #MSOMS

Instance View

INSTANCE VIEW

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

New SQL Server 2008/2008 R2/2012 MP Features and Fixes

  • Added support for databases stored on SMB Shares
  • Fixed error logging in a script for Blocking Sessions monitor
  • SQL 2005 MP files were excluded from the installer
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed Non-Readable Replica detection (Always On)
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

New SQL Server 2014/2016 MP Features and Fixes

  • Memory-Optimized Data Garbage Collection Fill Factor monitor and rule were disabled by default
  • Memory-Optimized Data workflows were disabled for all SQL Server instances, except for Developer, Enterprise, and Evaluation editions
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed issue: in some cases, Set Database Online/Offline tasks did not work for databases of SQL Server 2016 cluster instance
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.

The Operations Manager team encourages you to provide any feedbacks on the management packs by sending them to sqlmpsfeedback@microsoft.com

Creating Datacenter and Instance Dashboards

SQL Dash

With this System Center Management Pack CTP1 for SQL Server there is also an Awesome SQL Server Dashboard Guide to help you
building your own Dashboards in SCOM.

Entity Health

Here you can download the System Center Management Pack CTP1 for SQL Server and the Documentation.

 

SCUG Banner

Advertisements