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….

0

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…

0

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…

0

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…

0

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…

0

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…

0

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://blogs.technet.microsoft.com/kevinholman/2010/01/05/understanding-and-modifying-data-warehouse-retention-and-grooming/ DWDataRP https://blogs.technet.microsoft.com/momteam/2008/05/13/data-warehouse-data-retention-policy-dwdatarp-exe/     Download the link at the second link, and save to your machine (x86 or x64)  …

0

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…

0

SYSTEM CENTER 2016 Operations Manager – Anti-Virus Exclusions

NOTE: Process name exclusions could potentially prevent some dangerous programs from being detected. Therefore exclusions based on processes might expose to security issues and should be avoided.   As we are all aware, antivirus exclusions can affect monitoring data generated, and affect system performance.   Best practice is to implement specific exclusions. Hopefully this table…

0

SQL Engineering Blog

Ever wonder when a SQL MP is published? Wonder no longer, look for the SQL Engineering Blog!   New https://techcommunity.microsoft.com/t5/SQL-Server/bg-p/SQLServer/label-name/SQLReleases Old – redirect in effect https://blogs.msdn.microsoft.com/sqlreleaseservices/    

0