SQL Server 2016 Basic Availability Group with non-default endpoint port

SQL Server 2016 Basic Availability Group with non-default endpoint port

Antecedent During one of my latest implementations I configured a multi-subnet SQL Basic Availability Group (BAG) configuration in Azure. I also wrote a blog about that what you can read HERE. After that configuration, I was thinking about how to deploy 2 BAGs in the same SQL Instance using separate ports. As we know there […]

Unable to find Advisor Connector on this computer – SCOM 2016

Unable to find Advisor Connector on this computer – SCOM 2016

Antecedent The last implementation of a SCOM 2016 environment included 2 Gateway servers and integration to Operations Management Suite (OMS) in Azure. I used the final release of SCOM 2016 to deploy the servers and when all the infrastructure objects were in place I updated it with the recent Update Rollup (UR1). In the implementation […]

Azure multi-region & multi-subnet – Basic Availability Groups – SQL 2016 Standard Edition deployment for SCOM 2016

Azure multi-region & multi-subnet – Basic Availability Groups – SQL 2016 Standard Edition deployment for SCOM 2016

Overview In one of my last System Center Operations Manager 2016 deployments the databases were designed to run using Basic Availability Groups (BAGs are new in SQL Server 2016) hosted by a SQL cluster in Azure with nodes in 2 separated regions in 2 separate subnets. I was looking around the internet for about 2-3 […]

Extremely high Paged-Pool Memory on Windows Server 2012 R2 running SCOM component

Extremely high Paged-Pool Memory on Windows Server 2012 R2 running SCOM component

During my last project with a customer I had to build a small SCOM environment using 2012 R2 version with SQL Server 2014 SP1 as databases. The environment consists of the following components: 1 SQL 2014 SP server with named instance for Operations Manager database 1 SQL 2014 SP server with named instance for Operations […]

Configure SQL Monitoring Low-Privilege environment for SCOM (Part 1)

Configure SQL Monitoring Low-Privilege environment for SCOM (Part 1)

Part of my job as Cloud Consultant to configure System Center 2012 R2 Operations Manager environments including Management Packs. The one which causes most of the headaches is the Management Pack for SQL servers. The reason is that Microsoft changed the default permissions for LocalSystem when they release SQL Server 2012. Before that, LocalSystem (other […]