SQL Server 2008 R2 installed on a Windows Server 2008 R2 2-node cluster. Cluster validation wizard warns for SQL Server and SQL Server Agent services:
This resource is configured to run in a separate monitor. By default, resources are configured to run in a shared monitor. This setting can be changed manually to keep it from affecting or being affected by other resources. It can also be set automatically
by the failover cluster. If a resource fails it will be restarted in a separate monitor to try to reduce the impact on other resources if it fails again. This value can be changed by opening the resource properties and selecting the 'Advanced Policies' tab.
There is a check-box 'run this resource in a separate Resource Monitor'.
"Should" SQL Server and SQL Server Agent services run in shared (default) or separate monitors in this environment?
View Complete Post