Tag Archives: #SQL

SCOM: SQL Server MP updates v6.6.2.0

7 Replies

Microsoft has just released version 6.6.2.0 of the SQL management packs listed below. This updated contains fixes to many of the issues plaguing the previous version, of course test before using in your production environments.

SQL Server 2014 Replication – download here
SQL Server 2012 Replication – download here
SQL Server 2008 Replication – download here
SQL Server 2014 – download here
SQL Server 2012/2008/2003 – download here

Updates and Fixes in this version:

First the dashboards which had many issues in the original release.

  • Improved performance
  • Objects with selected monitors are now displayed on the top of the tiles list while editing
  • If there are no child elements, Related Objects tile is not displayed in Instance View.
  • Added Dark, Light and Contrast themes.
  • Introduced an interface upgrade allowing to display the Dashboard errors
  • User rights are now considered in the Dashboard display: the user can see the groups according to his/her access level only; Read-Only mode is implemented, it provides basic functions only: navigation, changing of the personalization settings
  • Fixed some UI errors, UI design upgraded
  • Fixed synchronization errors of the personalization settings.
  • Introduced a Dashboard feature allowing to display data from any nesting level within the widgets

SQL Server 2012/2008/2003

  • Added a support for disabled TCP/IP protocol
  • Fixed performance metrics error that may occur on some localized versions of Windows
  • Fixed bugs in monitor tiles on SQL Server Summary Dashboard
  • Fixed incorrect performance of Transaction log free space monitor
  • Added new type of events from failed discoveries; added a new rule that collects such events
  • Added overrides to prevent various scripts timeout failure
  • Removed some 1X1 tiles from Summary Dashboards
  • Filestream filegroups are excluded from discovery for now
  • 2008/2012 Summary Dashboards tiles were reorganized

SQL Server 2014

  • Fixed performance
  • Added a support for disabled TCP/IP protocol
  • Fixed performance metrics error that may occur on some localized versions of Windows
  • Fixed incorrect performance of Transaction log free space monitor
  • Added new type of events from failed discoveries; added a new reporting rule that collects such events
  • Added overrides to prevent various scripts timeout failure
  • Removed some 1X1 tiles from Summary Dashboards
  • Filestream filegroups are excluded from discovery for now
  • 2008/2012 Summary Dashboards tiles were reorganized
  • Added KB for Microsoft.SQLServer.2014.Mirroring.MirroringCommonGroupDiscovery
  • Summary Dashboard: added monitor/performance tiles to class “SQL Server 2014 Mirroring Groups”
  • Some minor fixes

SQL Server Replication MPs

  • Preset dashboards are updated

Loading

XPost: What SQL maintenance should I perform on my SCOM 2012 databases?

Leave a reply

Kevin Holman has updated his article on which SQL maintenance to perform on your SQL databases to now cater for the SCOM 2012 data structures.

The article which is available here and makes special mention of the types of maintenance which is run by SCOM itself which does not need to be handled by a SQL DBA.

Loading

SCOM: Updated SQL management packs v 6.6.0.0

Leave a reply

Microsoft has released updates of all of their SQL management packs to version 6.6.0.0, they are available for download at the links below, a brief what’s new is below the download links:

SQL Server 2005, 2008, 2008 R2, and SQL Server 2012 – Here
SQL Server 2014 – Here
SQL Server 2008 Analysis Services – Here
SQL Server 2012 Analysis Services – Here
SQL Server 2014 Analysis Services – Here
SQL Server 2014 Reporting Services (Native Mode) – Here
SQL Server 2012 Reporting Services (Native Mode) – Here
SQL Server 2008 Reporting Services (Native Mode) – Here

What’s new in 6.6.0.0

All of the management packs have had their dashboards replaced with new ones and the SQL Server management packs have the following additional updates:

newsqldashboard

SQL Server 2005, 2008, 2008 R2, and SQL Server 2012 v 6.6.0.0

  • Dashboards were replaced with the new ones
  • Components of replication functionality are deprecated and disabled by default
  • SPN monitor now correctly handles disjoined namespaces
  • Added support for filegroups containing filestreams and partition schemes
  • Memory Consumption monitor has been fixed
  • Upgradeability from 6.4.1.0 version is supported
  • Added CPU Usage monitor and rule for SQL Server 2005
  • Added ConsecutiveSamples Condition to the Buffer Cache Hit Ratio and Page Life Expectancy monitors
  • AlwaysOn discovery was reworked
  • Minor fixes.

SQL Server 2014 v 6.6.0.0

  • Dashboards were replaced with the new ones
  • SPN monitor now correctly handles disjoined namespaces
  • Added support for filegroups containing filestreams and partition schemes
  • Localization packs now works with the MP
  • Memory Consumption monitor has been fixed
  • Upgradeability from 6.4.1.0 version is supported
  • Added ConsecutiveSamples Condition to the Buffer Cache Hit Ratio, Page Life Expectancy, Transaction Log Free Space (%) and Resource Pool Memory Consumption monitors
  • AlwaysOn discovery was changed
  • Minor fixes.

sqlserver

Loading

SCOM 2012 R2: Support for SQL Server 2008 R2 SP3

Leave a reply

Over at the MS SCOM engineering Blog it’s been newly released that SCOM 2012 R2 now supports SQL Server 2008 R2 SP3.

There is a catch though see below for what to be aware of:

Issue: Fresh Install of SCOM 2012 R2 on SQL 2008 R2 SP3 will not work
Workaround: Deploy SCOM 2012 R2 on to SQL 2008 R2 SP2 and after installation upgrade the DB to SQL 2008 R2 SP3

Loading

SCOM: Unable to view overrides in Authoring pane when no scope is selected.

Leave a reply

An odd issue I encountered today at one of my customers that has recently completed a migration to SCOM 2012 R2, when trying to open the overrides node with no scope selected I got the following error “An object of class ManagementPackClass with ID <GUID Removed> was not found” and then the view shows 0 overrides until the console is reopened with a /clearcache.

Turns out this error is caused by having an override that references a class that no longer exists, in order to track it down you first have to access the overrides which you can no longer see unless you do the following:

1. Export your overrides to text file using poweshell by running get-scomoverride | out-file c:\SCOMOverrides.txt
2. Search the output text file for the GUID which was in the original error “An object of class ManagementPackClass with ID <GUID Removed> was not found”
3. The GUID will appear on a line labeled Context, below that one look for a line labeled Identifier, In my case it looked as follows “Identifier: 1|Windows.Operating.System.Custom.Monitors”
4. Generally this is enough information to identify which management pack needs to be deleted if it is not then continue to step 5
5. In SQL run the following query, remebering to edit it for your Identifier, against your operationsmanager database select * from ManagementPack where ManagementPackSystemName like ‘Windows.Operating.System.Custom.Monitors’
6. Once you have identified which management pack is causing your issue it needs to be deleted, once the new configuration is processed you will be able to see your overrides again.

Solution provided by Mcirosoft on Technet forum

Loading

SCOM: Database Status Report version 3

1 Reply

Last month I blogged about a SCOM Database Status Report that I was working on in order to get a single page overview of the SQL environment for a SCOM implementation, as a starting point to a complete SCOM heath report.

Below are samples of version 3 of the report which now includes additional sections for the OperationsManager database as well as the Data Warehouse. I have also amended some of the colouring to make important aspects easier to identify.

db1 db2 db3

 

I would be interested to hear from anyone who has any comments or suggestions on this report or ideas for future ones.

Loading

SCOM 2012 R2: Now supports SQL Server 2014

Leave a reply

This article was posted on the Operations Manager Engineering blog this week detailing the newly included support for SCOM 2012 R2 having SQL Server 2014 Enterprise, Standard (64-bit) as its database.

They note the following issues and workarounds to be aware of:

Issue: Installation to a SQL 2014 cluster using Cluster Shared Volumes (CSV) is blocked by SCOM 2012 setup.
Workaround: Deploy to a physical server and then use the documentation here to move the database to the CSV.

Issue: Upgrade of SQL SRS is blocked due to SCOM 2012 use of Custom Security Extensions.
Workaround: Uninstall SCOM Reporting and run ResetSRS.exe to clear the custom security extensions. Once that is complete, upgrade SQL and install SCOM 2012 reporting again. Can find similar steps in the documentation here.

Loading

SCOM: Database Status Report

2 Replies

I’ve been tinkering with trying to get a single health view for one of my clients SCOM environments.

I started with the SQL instance as this can be intensive to manually check every component.

Here is a sample of what it looks like so far my next step is to add free space information:

DB Status Report

 

Thanks to Dave Pinal for his post giving me a starting point.

Please leave a comment if you have any suggestions as to what else can be added or if you have something similar.

Loading

SCOM: Updated SQL MP version 6.5.4.0

Leave a reply

An updated version of the SQL Server Management Pack was released this week, the new version is 6.5.4.0. This updated focuses on minor improvements and fixes.

They are available for download at the following links:

SQL Server 2005, 2008, 2008 R2 – here

Changes in this version:

  • Added Mirroring monitoring scenarios for SQL Server 2012 product
  • SPN monitor now has overridable ‘search scope’ which allows the end user to choose between LDAP and Global Catalog
  • Fixed the error with blocked discovering DBs on Windows 2003
  • Fixed Timeout error in CPU utilization monitoring scenario
  • Monitoring SQL Server Instances on the same server with their own network interfaces and default port is now available
  • SQL Server instances with underscores and other allowed special symbols in names can be monitored
  • Minor fixes.

SQL Server 2014 – here

Changes in this version:

  • Added Mirroring monitoring scenarios for SQL Server 2014 product
  • SPN monitor now has ‘search scope’ parameter which allows the end user to choose between LDAP and Global Catalog
  • Fixed Timeout error in CPU utilization monitoring scenario
  • Monitoring SQL Server Instances on the same server with their own network interfaces and default port is now available
  • SQL Server instances with underscores and other allowed special symbols in names can be monitored
  • Minor fixes.

Loading