Blog Archiv

Neue Version 6.7.2.0 SCOM SQL Management Pack

Bewertung:  / 0
Montag, 01. August 2016 TPE

Seit langer Zeit hat Microsoft eine neue Version des SQL Management Packs inklusive der Dashboards freigegeben. Die Liste der Anpassungen und Verbesserungen ist entsprechend lang:

SQL MP:

•Created a group for WOW64 SQL Server instances and disabled launching some workflows for these instances
•Added MP version line into MP's events generated by scripts
•Fixed display strings and Knowledge Base articles
•Fixed: some scripts do not return data when one of few installed instances is stopped
•Fixed: SPN configuration monitor uses stale data
•Fixed: Mirroring monitoring scripts fail when instance is stopped
•Fixed Always On Database replica discovery incorrect behavior; fixed Always On policies discovery and monitoring
•Fixed Database policies discovery and monitoring
•Fixed and optimized CPU Usage monitoring scripts (the issue appeared when only one core was assigned)
•Added support for more than 32 processors count in CPU Usage monitoring.
•SQLPS module is now used for the tasks instead of deprecated SQLPS.EXE
•Implemented FILESTREAM filegroup monitoring
•Multiple Ports are now supported in SQL Server TCP/IP parameters
•Fixed error occurring when no port is specified in SQL Server TCP/IP parameters
•Fixed filegroup read-only state discovery
•Fixed RunAs profiles mapping for some workflows
•Implemented support for TLS 1.2 in connection logic
•Implemented support for different client drivers in connection logic
•Updated connection logic error logging
•Added RunAs profiles for mirroring monitors, fixed mirroring discovery issues
•Fixed issue: CPU usage monitor ignored SQL server limitations on CPU core count
•Fixed display strings and Knowledge Base articles
•Fixed error reporting in the scripts
•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 filegroups 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

SQL MP Dashboards:

•Added a feature to Bulk Add tiles from the class definition.
•Added a feature to ignore some states while calculating the worst state for the Datacenter View State Tile; added a feature to set this ignorance up for each group
•Added a feature to show/hide Instance path in the list on the Instance view
•Added instance path to the Instance Details
•Implemented deferred loading of the instance tiles to make the instance view operation faster
•Implemented a new format for Dashboards configuration providing a smaller size and a single binding
•Implemented a converter from old to new format providing preservation of user changes
•Improved error reporting
•Improved performance of initial load process
•Improved data sources performance
•Improved performance of instance selection (made it asynchronous)
•Improved performance of Datacenter and Instance View Tiles, loading and loaded animations
•Fixed animation issues and minor visual glitches (positioning, size of elements, fonts, main loading animation)
•Updated Summary dashboard
•Fixed animation, styles and display issues
•Updated Path search and display
•Added removal of unused elements
•Fixed filter and search issues
•Fixed "Show/Hide Path" button in Silverlight
•Implemented a deferred loader
•Improved drilldown process
•Fixed group adding process
•Fixed HighLight; simplified tile adding process
•Added support for SQL Server Replication 2016 MP objects in Summary dashboard
•Fixed The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection exception.
•Replaced 999+ presentation with a new one (26.2k)
•Added configurable rule to pre-aggregate data in the DW (see the corresponding Known Issue)
•Added second row in the instance view to show Path of the object, and allow searching by Path.
•Fixed tooltip presentation on the Instance view
•Known issues and Troubleshooting section of the guide is updated

Um das Laden der Dashoards zu beschleunigen (was definitiv eine gute Idee ist), kann man die beiden folgenden SQL Statementents regelmäßig gegen die Datawarehouse Datenbank ausführen lassen:

EXECUTE [sdk].[Microsoft_SQLServer_Visualization_Library_UpdateLastValues]
EXECUTE [sdk].[Microsoft_SQLServer_Visualization_Library_UpdateHierarchy]

Weitere Details dazu sind hier zu finden: SCOM: SQL Dashboards workaround for slow performance

 

Microsoft System Center 2012 R2 Update Rollup 10

Bewertung:  / 0
Freitag, 17. Juni 2016 tpe

Das zehnte Update Rollup für System Center 2012 R2 ist erschienen.

Hier die Links auf die einzelnen folgende Komponenten:

  • Data Protection Manager (SCDPM) -> KB3143871
  • Operations Manager (SCOM) -> kein Update
  • Operations Manager - UNIX und Linux Monitoring -> kein Update
  • Orchestrator -> kein Update
  • Service Manager (SCSM) -> kein Update
  • Service Provider Foundation -> KB3147172
  • Service Reporting -> kein Update
  • Virtual Machine Manager (SCVMM) -> KB3147167
  • Windows Azure Pack (WAP) -> KB3158609
  • Windows Azure Pack Web Sites Version -> kein Update

Eine Übersicht dieses Updates ist unter folgenden KB-Artikel KB3164172 verfügbar.

Für den Operationsmanager gibt es diesmal keine Updates.

 

SQL Run As Accounts nicht mehr zwingend nötig

Bewertung:  / 0
Montag, 02. Mai 2016 TPE

Der neuste Blog Artikel von Kevin Holmann ist ein Meilenstein für die Überwachung von SQL Servern mit dem Operations Manager.

Ein jeder SCOM Adminstator kennt die Herrausforderung einen SQL Server zu überwachen, wenn der "Local Systen Account" keine Rechte auf dem SQL Server mehr besitzt (ab SQL 2012 ist das der Standard). In diesen Fällen wird ein zusätzlich Run As Account benötigt, der im SQL entsprechende Rechte erhalten und zusätzlich auch noch auf die System verteilt werden muss. 

Das muss aber nicht mehr so sein. In seinem neusten Blog Artikel beschriebt Kevin Holmann eine Lösung, die auf der Art und Weise basiert, wie auch die Operations Manager Suite (OMS) auf SQL Server zugreift. Er beschreibt nicht nur die Lösung, sondern liefert gleich auch noch ein freies Management Pack mit, in dem er die beiden notwendigen Schritte als Tasks mit liefert.

Einfach nur Genial - an dieser Stelle ein großes Dankeschön!

Den Artikel findet ihr hier: SQL MP Run As Accounts – NO LONGER REQUIRED

Das zugehörige Management Pack hier: SQL-Server-RunAs-Addendum

 

Microsoft System Center 2012 R2 Update Rollup 9

Bewertung:  / 0
Montag, 01. Februar 2016 tpe

Das neunte Update Rollup für System Center 2012 R2 ist erschienen.

Hier die Links auf die einzelnen folgende Komponenten:

  • Data Protection Manager (SCDPM) -> KB3112306
  • Operations Manager (SCOM) -> KB3129774
  • Operations Manager - UNIX und Linux Monitoring -> kein Update
  • Orchestrator -> kein Update
  • Service Manager (SCSM) -> KB3129780
  • Service Provider Foundation -> KB3133705
  • Service Reporting -> kein Update
  • Virtual Machine Manager (SCVMM) -> KB3129784
  • Windows Azure Pack (WAP) -> KB3129786
  • Windows Azure Pack Web Sites Version -> KB3129789

Eine Übersicht dieses Updates ist unter folgenden KB-Artikel KB3129757 verfügbar.

Für den Operationsmanager gibt es diesmal diese Fehlerbehebungen:

  • Application Pool worker process crashes under APM with heap corruption
  • Some Application Pool worker processes become unresponsive if many applications are started under APM at the same time
  • MOMAgent cannot validate RunAs Account if only RODC is available
  • Missing event monitor does not warn within the specified time range in SCOM 2012 R2 the first time after restart
  • SCOM cannot verify the User Account / Password expiration date if it is set by using Password Setting object
  • SLO Detail report displays histogram incorrectly
  • APM support for IIS 10 and Windows Server 2016
  • APM Agent Modules workflow fails with Null Reference exception during workflow shutdown
  • AEM Data fills up SCOM Operational database and is never groomed out
  • The DownTime report from the Availability report does not handle the Business Hours settings
  • Adding a decimal sign in an SLT Collection Rule SLO in the ENU Console on a non-ENU OS does not work
  • SCOM Agent issue while logging Operations Management Suite (OMS) communication failure.