SQL Server Resource Governor Monitoring reports

Resource Governor is an extremely cool and powerful feature that, when implemented, can manage the consumption of CPU and memory resources.  I will not be going into the details of Resource Governor, or even how to set it up as this is extensively documented in Books Online.  What I will be talking about today is…


SQL 2012 System Health Reporting Dashboard – Visualizing sp_server_diagnostics results.

We have introduced the System Health Session in SQL 2008 in order to capture some critical Events to make post mortem analysis much easier. However in SQL 2008, by default the system_health session was only collected to a ring buffer and not persisted to disk. SQL 2012 truly provides more of a black box recorder…


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


Merge Replication Conflict Detection vs Conflict Resolution Part 2: Custom Business Logic Handler

Attached is a sample Merge Conflict Handler sample I created.  I am including a walkthrough of the sample below.   1.  Create the sample merge publication/subscription databases Code Snippet:  From file  <1-CreatePub_Sub_DBs.sql>   2. Via management studio or TSQL scripts ( file 2-CreatePublication.sql) , create the merge publication ·         For Publication name specify: SamplePub1 ·        …