Microsoft recently released a new Microsoft SQL Server Management pack for SCOM 2012. Here’s my experience importing and reviewing its new features/general operation.
The MP can be downloaded here and it has a decent set of new features and fixes:
New features and fixes:
- 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 18.104.22.168 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.
After installing it, the files will be located on a folder.
All you have to do is import from disk.
You won’t need all of them, very likely. Make sure you only import MPs that you’ll actually going to use. In my case, only these:
But not. I’ve just looked and noticed I had imported the SQL 2008 pieces as well as the always on feature. I will then update the SQL 2008 and remove the Always on, since I’m not using it at this moment:
OK.All good now.
First looks at the console show some new cool dashboards…but not. When I clicked, I’ve got a funny message that the dashboard didn’t exist or had been removed.
As usual, closing and re-opening the SCOM operations Console fixed the issue. Here’s a quick sample of the new dashboards:
It looks great. This is called the Datacenter view. If you (double)click on any of the tiles, you will get more information (databases):
This is great, but there is more! The SQL team has been so generous in creating those dashboards that they will also share these with other platforms.
Yes, yes. That’s what you think: you can leverage this same visualization to show information about other objects. Let’s give it a try!
To the batworkspace!
Look at that!
The new dashboard will be a bit quiet, but let’s fix this:
Nothing cat beat the classics. Let’s pick All Windows Computers:
This is a brand new SCOM, so, not a lot of stuff there, but makes sense:
The nice thing about it is that you can add multiple groups:
Settings allow for changes in the refresh interval and colours:
Summary: couldn’t find any operational flaw yet but will keep you posted. As for visualization, it is a great improvement. Thank the SQL team for developing and sharing this!
Hope this helps!