Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Processor Affinity and Clustering Expand / Collapse
Author
Message
Posted Wednesday, May 12, 2010 4:51 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 6:01 AM
Points: 53, Visits: 564
I've got an N+1 cluster split between 2 instances (one 2k5 and the other 2k) and server resources split 60/40 (processor and memory)
I've started setting up maintenance jobs including Checking Integrity on the sql2005 side but ran into trouble with Failed0) Alter failed for Server 'servername'.
I tired checking the configuration as recommended by a couple of sites but ran into this error
Msg 5834, Level 16, State 1, Line 1 The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration.

So I set the Automatically set I/O affinity mask for all processors in the server properties as recommended here
http://www.waldonell.com/me/node/328

Question: How does this effect a clsuter? Will the processors still be shared?
Post #920327
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse