Tag: SQL

#MSOMS Is Not #SCOM

I’ve been meaning to write this blog post for a long time. The reason for that is because since the first preview of OMS (Operational Insights back in the day) I’ve received question like “I’ve removed the Microsoft Monitoring Agent from my server but why I still see the server in OMS?” trough various channels. And btw if you wonder how long I’ve been using OMS today is exactly 2 years and 3 months since it was announced at TechEd North America 2014. I probably should be getting some honorable badge for this achievement Smile . Back to the topic. While there are scenarios in which you can think of OMS like it is SCOM in many ways you should not and there is reason for that. I will try with this blog post to explain why and answer the above question. We can summarize the differences between Operations Management Suite and SCOM in the following statements: Continue reading “#MSOMS Is Not #SCOM”

Advertisements

Microsoft Azure Operational Insights Preview Series – SQL Assessment (Part 7)

During the last couple of months System Center Advisor or as probably will be known as Microsoft Azure Operational Insights Preview after TechEd Europe 2014 has received a lot of improvements and feature so we are now to Part 7. With this blog post I am also renaming all other blog posts. Here is the full list:

In this post we will have a quick look at a new intelligence pack called SQL Assessment: Continue reading “Microsoft Azure Operational Insights Preview Series – SQL Assessment (Part 7)”

Where is My SQL SCOM Dashboard Performance Data?

I’ve seen cases where you have SCOM 2012 or higher and latest SQL Management Pack but the performance data is not showing in the SQL dashboards for some or for all of your SQL servers: Continue reading “Where is My SQL SCOM Dashboard Performance Data?”

New and Updated MPs: SQL Server

Today we see some MPs being updated and some new ones released all related to SQL:

New MP: System Center Management Pack for SQL Server 2014

There is a new SQL MP and it is for SQL Server 2014 only. A good overview of this new MP you can find on Oleg Kapustin’s.  You can download it from here. Remember to read the guide first before implementing it.

Fixing Event ID 31553 On SCOM Management Server

On a SCOM management server I’ve noticed event ID 31553 logged a lot constantly and in detail the error looked like this: Continue reading “Fixing Event ID 31553 On SCOM Management Server”

SQL 2012 and System Center 2012 R2 Guide

I cannot stress enough how important is to have some SQL knowledge when dealing with System Center. I’ve previously blogged about SQL Server guide for System Center 2012 by Paul Keely and I’ve personally used this guide many times when I was designing System Center environment and now there is a new version SQL 2012 and System Center 2012 R2. Actually it is not exactly a new version but more extension to the first guide as many of the stuff are still relevant. If you haven’t checked the first guide do it but also definitely check the new one to learn some cool stuff.