Identify orphaned agent properties

  Back again, I’m going to ‘Identify orphaned agent properties’.  For instance, does an agent still show up under Windows Computer, or more classes, like Windows Operating System?  Typically we have handled this by using Holman’s purge blog.       Deleting and Purging data from the SCOM Database     First, my thanks to […]

SQL on Windows Addendum pack

It’s spring time; time to tune the SQL carb!   Carbs are way less easy to find these days, but I’ve been busy tuning the SQL agnostic pack (MSSQL on Windows).   Tuning the SQL Agnostic pack would be far less successful without expert help.  My thanks to Brandon Pires – MCS SQL Consultant who […]

Workflow Manager Addendum MP for SQL Aliases

  A SQL Alias is kinda like wearing disguise glasses…   From a security perspective, you can make things difficult for attackers by specifying a SQL alias and different port for SQL.       Symptom – discovery fails for WFM pack   Trying to monitor and figure out what the real database name, instance, etc. […]

Possible SQL issues affecting SCOM performance

  Good reasons for a Risk Assessment   SQL RAS runs 800+ queries to check on target SQL servers Check Best Practice Recommendations (BPR)   May be good opportunity to audit the SQL build for BPR!       Ran across some good examples where SQL settings brought SCOM to a standstill One was Cardinality […]

What ID’s is SCOM using

Ever need to audit what ID’s SCOM is using? Maybe you have to figure out how someone else setup SCOM. Did they set up SCOM as recommended for best practices with different AD accounts per role?   If the ID’s are not logged during install, it’s a little more difficult to figure out what ID […]

2016 SQL SP1 patch issue

False alert?   If you have SQL2016 SP1 monitored in SCOM, you most likely have Compliance monitor warnings   This is actually a problem with SP1 where SQL did not update the registry key.     Two options to remedy: Disable SCOM monitor per instance (or class if SP1 is NOT in your environment) Fix the […]

SQL native client for TLS1.2

Ever try to talk to someone when language is a barrier?   Sure, we can run an app, or search our phrase to pronounce, but it’s so much better when we can communicate seamlessly.   Post TLS1.2 for SCOM Let’s talk SQL Part of TLS1.2 is updating SQL Native Client to talk using a secure […]

Set up SCOM 2016 for TLS1.2

Security bugging you about SCOM using TLS1.0 ?   Have questions on the TLS1.2 Protocol Support Deployment guide link? If using ACS, please review ACS steps to configure from the guide above   It’s time to update SCOM 2016 to TLS1.2!   Pre-requisites .Net and SQL native client, ODBC must be updated to TLS1.2 compliant version HTTPS Endpoints […]

Use DWdataRP utility on SCOM2016

Extra, Extra, read all about it! The DWdataRP utility works on SCOM2016     This tool has been around since SCOM 2007, and blogged about by Kevin Holman and the SCOM Engineering Team DW Retention https://kevinholman.com/2010/01/05/understanding-and-modifying-data-warehouse-retention-and-grooming/ DWDataRP https://techcommunity.microsoft.com/t5/System-Center-Blog/Data-Warehouse-Data-Retention-Policy-dwdatarp-exe/ba-p/340415?search-action-id=139683980150&search-result-uid=340415     Download the link at the second link, and save to your machine (x86 or x64)   […]

Optimize SQL for SCOM

Maybe I’m old school, but do you ever feel like optimizing SQL is like playing a video game? Keep on shooting, hopefully you don’t hit your thrusters and drift and then die!   Does your SQL DBA Team (or did you): NTFS Allocation Unit set to 64KB for the SQL Server drives Dedicate memory for […]