Blog Archiv

Microsoft System Center 2012 R2 Update Rollup 11

Bewertung:  / 0
Freitag, 02. September 2016 tpe

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

Hier die Links auf die einzelnen folgende Komponenten:

  • Data Protection Manager (SCDPM) -> KB3162908
  • Operations Manager (SCOM) -> KB3183990
  • Operations Manager - UNIX und Linux Monitoring -> Download Linux/Unix MP
  • Orchestrator -> kein Update
  • Service Manager (SCSM) -> kein Update
  • Service Provider Foundation -> KB3184834
  • Service Reporting -> kein Update
  • Virtual Machine Manager (SCVMM) -> KB3184831
  • Windows Azure Pack (WAP) -> kein Update
  • Windows Azure Pack Web Sites Version -> KB3174243

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

Fixes für den Operations Manager

  • Network discovery fails because of monitoring host crash if no paging file is set on the operating system
  • Backport PuTTY 0.64 and 0.66 updates from 2016 release
  • Update Register-SCAdvisor cmdlet for WEU workspaces
  • ACS eventschema.xml has incorrect parameter mappings for multiple audit events
  • Memory leak when monitoring network devices by using SNMPv3
  • Web Console user can view datawarehouse performance or SLA widget data outside of their scoped dashboard views
  • Downtime duration doesn't take business hour into consideration
  • Cisco 3172 PQ network device certification issues
  • Adding SCOM assessment links in the Operations Management Suite view in the SCOM console
  • SQL Server Seed relationship with a server that is running Windows
  • Alert subscriptions are not always fired for 3 state monitors
  • When you connect SCOM to OMS, Availability monitors health state of some management servers changes to Warning state
  • RunAs Account password expiration does not work with Active directory Password Settings Objects that breaks the validation of LOCAL User Accounts
  • MPB Entries in Catalog database for the VersionIndependentGuid column is updated
  • If the first try of importing MPB failed then re-importing the MPB was not possible until the SCOM console is closed and reopened
  • Change of the displayname field for a group in a sealed or unsealed management pack

Issues that are fixed in the UNIX and Linux management packs:

  • New Linux operating system versions supported Ubuntu Linux 16.04 LTS (x86 and x64) is now supported in System Center 2012 R2 Operations Manager.
  • During UNIX/Linux computer discovery, the GetOSVersion.sh script is run with sudo elevation if a sudo-enabled user is selected for Discovery. This update prevents the GetOSVersion.sh script from being run with sudo elevation and does not have to be authorized in the /etc/sudoers folder.
  • Scripts executed by the ExecuteScript method in Management P
  • UNIX or Linux computers together with sshd versions that implement the Key Exchange Algorithms described in RFC 4419, such as Ubuntu 15.10, cannot be discovered with the Discovery Wizard.
  • Network statistics collected on AIX servers are reset when another tool such as NetStat is also used.
  • Physical disks are shown incorrectly as offline if an LVM snapshot is taken.

 

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