Marcelo Sincic | novembro 2016

Complementando o post anterior sobre os novos Management Packs atualizados após o lançamento do Windows e System 2016 (http://www.marcelosincic.com.br/post/new-system-center-operations-manager-2016-management-packs.aspx), segue atualização.

Foi liberado hoje o Preview do novo Management Pack para SQL desde a versão 2008 até 2016.

Importante que este preview já resolve alguns problemas que ocorreram com bases de dados e indicadores na console do SCOM 2016:

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 cashed 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 cashed 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