Public Preview for SQL Server vNext Management Pack and More Released

Microsoft extends support of platforms for SCSM 2016, releases Public Preview for SQL Server vNext Management Pack, System Center MP for SQL Server, Replication, AS, RS, Dashboards (6.7.15.0).

Share online:

Microsoft released a new cumulative update of Windows 10 for PCs build 14393.594 to the Release Preview ring.

The new update is listed as KB3209835 is released to the Insiders on the Release Preview ring in December. As of now, no changelog has been released. However, if your computer is currently configured to be in the Release Preview ring, you can then grab the update by heading over to Settings > Update & security > Check for updates.

Service Manager 2012 R2

Meanwhile Microsoft has extended the support of following platforms for Service Manager 2016:

Support of SQL server 2014 SP2 for both SM 2016 & 2012 R2. "Service Manager 2016 and Service Manager 2012 R2 with Update Rollup 9, now officially support Service Pack 2 for SQL Server 2014 for hosting your Service Manager CMDB and Data Warehouse databases," writes Microsoft.

Microsoft also notes that Service Manager 2016 console installation will now be supported on Microsoft Windows 7. This will require installation of .NET 4.5.1 as a pre-requisite for Windows 7 to support the SM 2016 console.

Further the company said, the new spell check feature which was introduced in the Service Manager 2016 console, will have limited language support on Windows 7 include English, French, German and Spanish.

Lastly, support for System Center 2012 R2 Virtual Machine manager, Orchestrator, Operations Manager and Configuration Manager (including SCCM 1511, 1602 and 1606) to be used with Service Manager 2016 connectors is announced as well.

Public Preview for SQL Server vNext Management Pack released covers a subset of monitors and rules, and will bring full functionality with new CTPs release. The most important new features included with this CTP are as follows:

  • X-platform opportunities came true: monitor SQL vNext on Linux and SQL vNext on Windows!
  • Agentless monitoring is now available along with traditional agent monitoring. The monitoring workload can be transferred to management servers included in the SQL Server vNext Monitoring Pool.
  • Usage of scripts is discontinued in favor of .Net Framework modules, which enables more efficient resource usage.
  • For getting information on health and performance, SQL Server Dynamic Management Views and Functions are now used instead of WMI calls. This provides better efficiency and connectivity.

All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack here.

Microsoft has alsow announced new updates to SQL Server Management Pack family. All Management Packs are available in all 11 languages! The following table shows the new features and improvements:

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

  • No extra permissions on remote WMI are now required for Local System account when Always On hosts have names that are no longer than 15 symbols
  • Fixed: Always On discovery and monitoring scripts cannot read cached values in Windows registry
  • Fixed: Wrong MP version number in some Always On scripts
  • Fixed: CPUUsage and DBDiskLatency scripts fail with the reason: "Index operation failed"
  • Added retry policy in some Always On workflows to make PS-scripts work more stable
  • Updated the visualization library
  • Changed behavior of Always On scripts for cases when WSFC service is stopped

New SQL Server 2014/2016 MP Features and Fixes

  • No extra permissions on remote WMI are now required for Local System account when Always On hosts have names that are no longer than 15 symbols
  • Fixed: Always On discovery and monitoring scripts cannot read cached values in Windows registry
  • Fixed: Wrong MP version number in some Always On scripts
  • Fixed: CPUUsage and DBDiskLatency scripts fail with the reason: "Index operation failed"
  • Added retry policy in some Always On workflows to make PS-scripts work more stable
  • Updated the visualization library
  • Fixed: Always On objects get undiscovered when any Always On discovery crashes

New SQL Server Replication 2008/2012/2014/2016 MP Features and Fixes

  • Added support for configurations where computer host names are longer than 15 symbols
  • Fixed: MonitorDistributorSnapshotFreeSpace fails when being launched against SQL Server 2014 SP2
  • Fixed: Wrong source detection in logging
  • Updated the visualization library

New SQL Server Analysis Services 2008/2012/2014/2016 MP Features and Fixes

  • Added support for configurations where computer host names are longer than 15 symbols
  • Fixed: AS workflows sometimes crash
  • Updated the visualization library

New SQL Server Reporting Services 2008/2012/2014/2016 MP Features and Fixes

  • Added support for configurations where computer host names are longer than 15 symbols
  • Fixed: Web Service monitors do not support URL reservation https://+:<port>/<ReportServerPage> (protocol is HTTPS)
  • Updated the visualization library

New SQL Server Dashboards Features and Fixes

  • Fixed: Tiles content is replaced with question signs after a long period of inactivity

More detailed information, you can downloaded guides along with packs from the following links: