Tag Archives: SQL

Installing SQL 2016 for System Center Operations Manager (SCOM) 2016 – Step-by-Step

The following is a guide on how to install SQL 2016 for your System Center Operations Manager (SCOM) 2016 environment. I will be installing SQL 2016 on a brand-new server with Windows Server 2016 installed. To begin, I am going to set the following accounts as a Local Administrator on the server. Also, I am […]

Step-by-Step Upgrading to SCOM 2016 from SCOM 2012 R2

So you’ve decided to take the jump and upgrade to System Center Operations Manager 2016? Assuming you are running a SCOM 2012R2 (UR11) environment, this post will be exactly what you need to have a successful SCOM 2012 R2 to SCOM 2016 upgrade. **Although the recommended path is to upgrade from UR9** In my environment, […]

#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. […]

SLA Information via SQL

The System Center Operations Manager data warehouse contains a wealth of information that can be surfaced by running reports in the console. However, using reports isn’t the only way you can extract valuable information from SCOM; you can also write tiny snippets of SQL to return exactly what you need to see. Recently, we had […]

OMS SQL Assessment Solution

First things, first, what is the SQL Assessment Solution? OMS SQL Assessment Solution does exactly what it sounds like, it assesses a given SQL environment, providing a health check and risk assessment. The solution executes on a fixed (for now) interval monitoring and evaluates your SQL environment. With the solution, it provides six focus areas, […]

Snap Manager Management Pack V1

Since June I have been building this MP to help my teams track the status of multiple Snap Manager based programs.  This is the initial release of this work.  You will find details on the following three items Snap Manager for Exchange Snap Manager for SQL Snap Manager for SharePoint 8 aka DocAve. There are […]

A must-have for SCOM users: Dashboards by Savision by MIcrosoft MVP Marius Sandbu

Have you ever tried working with the Web Console in Operations Manager? It has not been widely adopted since (like most of the System Center web components) it relies on Silverlight, which is slowly being phased out by Microsoft. There are many Microsoft partners that have seen that there is a gap to fill here […]

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 […]

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: In such case the solution can be simple as rebuilding SQL WMI described here: http://support2.microsoft.com/kb/956013 I also recommend restarting the […]

New and Updated MPs: SQL Server

Today we see some MPs being updated and some new ones released all related to SQL: Updated: System Center Management Pack for SQL Server (2012, 2008 R2, 2008, 2005) Updated: System Center Management Pack for SQL Server 2014 New: System Center Management Pack for SQL Server 2008 Reporting Services (Native Mode) New: System Center Management […]