KBI 310452 Enhancement: Powershell Script Rules In Argent for SQL Server For Checking Powershell Based Failover Clustering

Version

Argent Advanced Technology 1304-L and above

Date

Friday, 3 May 2013

Summary

Argent Advanced Technology has been enhanced with a new Rule ‘Powershell Script Rules‘ in Argent for SQL Server to check regularly for any cluster failover

Technical Background

If a cluster is unbalanced, instances can contend for memory and performance can degrade severely. It is recommended to check regularly for failover and if the instance is on its preferred node

Note: This does require PowerShell 2.0 and that the target nodes have ‘Failover Clustering’ installed

Resolution

N/A