SQL Server Workgroup Cluster FCM Errors

Background One of the new features of SQL Server 2016 is the ability to use SQL Server with Failover Cluster in a workgroup rather than joined to Active Directory. When working with SQL Server and Failover Clustering in a workgroup, many of the abilities that are normally used with Active Directory are no longer available,…

0

Get the Active Power Plan of Multiple Servers with PowerShell

  It is a widely known and discussed performance hit when you don’t have an optimal power plan set on your database servers.  This is one of those easy ways to get great gains by simply flicking a switch…almost literally. But what happens if you have hundreds or thousands of servers under your responsibility?  The…


Use PowerShell Script via startup Agent Job to balance Memory between two instances on a cluster on a Failover

Scenario: You have a two instance, two node cluster. SQL1 is typically running on Node1, SQL2 is typically running on Node2. The Objective is to maximize memory usage when each instance is running on its own node, yet balance memory usage if both of them happen to run on the same node.      …