Category: SQL

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:

MP could not write out CCM setting to WMI Error in System Center 2012 R2 Configuration Manager

Even though SCCM is not my main area of expert I sometimes use it and troubleshoot it. Recently my Management Point server was giving the following error: Continue reading “MP could not write out CCM setting to WMI Error in System Center 2012 R2 Configuration Manager” →

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.