74 8
Part V: Enterprise Data Management
■ (^3) : Failover or restart on critical server errors
■ Triggered level 1 or level 2 error OR
■ (^) Sp_server_diagnostics returns “system error”
■ 4 : Failover or restart on moderate server errors
■ (^) Triggered level 1, 2 or 3 error OR
■ Sp_server_diagnostics returns “resource error”
■ (^5) : Failover or restart on any qualifi ed failure condition
■ Triggered level 1, 2, 3, or 4 OR
■ (^) Sp_servier_diagnostics returns “query_processing error”
By default, FailureConditionLevel 3 is used meaning that if the SQL Server service does not
respond, sp_server_diagnostics times out or sp_server_diagnostics returns a system error;
then a failover or restart will occur.
Default values used to perform health checks and take actions should be changed only to resolve specifi c problems,
and you should be fully aware of any potential impact.
Confi guring Clustering
Although clustering Windows would normally be undertaken by the Systems Administration
team, you may have to do this if you work in a small shop. It is also good to have an aware-
ness of how to cluster Windows Server because it can help you with troubleshooting efforts
in the event of an issue.Confi guring Windows Server 2008/2008R2 for Clustering
The process to confi gure Windows Server 2008/2008R2 clustering involves initial prepara-
tion steps such as setting up the right network confi guration, installing required server
roles and role services, and installing necessary server features.Network Configuration
To ensure that cluster communications are not interrupted, you confi gure two networks. One
network will be used for all public traffi c and the other network for private internal commu-
nications. The private network should be confi gured to be nonroutable and have a unique IP
address. If your domain network is not the fi rst bound network on your server you may get a
warning during setup. If this happens refer to http://technet.microsoft.com/en-us/
library/dd391967(WS.10).aspx for adjusting the network binding order.c29.indd 748c29.indd 748 7/31/2012 9:51:58 AM7/31/2012 9:51:58 AM
http://www.it-ebooks.info