SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


setting up Clustering - SQL Server 2008 R2


setting up Clustering - SQL Server 2008 R2

Author
Message
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19810 Visits: 17242
Jpotucek (9/10/2012)
can anyone same MS Professional Services : )

don't understand, what does this mean?


Jpotucek (9/10/2012)
So speaking specifically how the drives would need to get carved out, I already have a 2 node active passive cluster on sql server 2005 and the drive configuration looks like this:

C: Local to each node (for Biniaries) (50GB)
D: Local to each node (for misc files) (85GB)
Q: Quorum (1GB)
M: MSTSC (1GB)
F: Shared on the San (datafiles) (300GB)
G: Shared On the San (Logfiles) (300GB)
H: Shared on the San (TempDB) (50GB)
____________________________________________________________
My 2008R2 Cluster with 3 Instances, will would look like this:
Default Instance
C: Local to each node (for Biniaries) (50GB)
D: Local to each node (for misc files) (85GB)
Q: Quorum (1GB)
M: MSTSC (1GB)
F: Shared on the San (datafiles) (100GB)
G: Shared On the San (Logfiles) (100GB)
H: Shared on the San (TempDB) (50GB)

Named Instance 1
I: Shared on the San (datafiles) (100GB)
J: Shared On the San (Logfiles) (100GB)
K: Shared on the San (TempDB) (50GB)

Named Instance 2
L: Shared on the San (datafiles) (100GB)
M: Shared On the San (Logfiles) (100GB)
N: Shared on the San (TempDB) (50GB)

Named Instance 3
R: Shared on the San (datafiles) (100GB)
S: Shared On the San (Logfiles) (100GB)
T: Shared on the San (TempDB) (50GB)

Or does each install create a new Quorum Drive as well because you are actually adding a Node?

You only have one quorum resource for the windows cluster whether it be a disk or file share, etc.

With the above configuration for your new cluster you may want to look at using mount points to cut down on the drive assignments and yep, you guessed it, heres a link to my guide on this site :-D

Cool

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Jpotucek
Jpotucek
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1552 Visits: 1677
"You only have one quorum resource for the windows cluster whether it be a disk or file share, etc."

So my Disk config looks OK.. One quorum disk regarless of the # of Instances?
and... Take a look a mount points? : )

You da' bomb! Thanks for all your guidance



Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19810 Visits: 17242
You dont have a quorum resource for each instance installed, the cluster as a whole at the windows level has one quorum resource.

The resouce can be node majority for odd number of cluster nodes or disk or file share for even number of nodes.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Jpotucek
Jpotucek
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1552 Visits: 1677
Thank you. that makes much more sense now. :-D

and also .. when I said this:
"can anyone same MS Professional Services : )"

I meant to say:
"can anyone say MS Professional Services?"
meaning.. Crying why didn't I hire MS professional services for this!!!!!!

Actually, I can't wait to dig into it! Thanks for all your guidance Perry!



Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19810 Visits: 17242
Jpotucek (9/10/2012)
why didn't I hire MS professional services for this!!!!!!


No need to pay over the odds, You just merely need to hire a good contractor to design\install the system and provide onsite training.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
sql-lover
sql-lover
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1577 Visits: 1930
Perry Whittle (9/10/2012)

See my 3 part guide starting at this link to deploy and configure the Windows cluster and the clustered SQL server instance. It covers virtual but applies to physical too

See my guide at this link for details how to slipstream service packs and\or cumulative updates


Thanks for sharing!
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19810 Visits: 17242
you're welcome ;-)

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Jpotucek
Jpotucek
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1552 Visits: 1677
one last point for clarification?? Blush

So (if I have this straight) There is one Quorum and one MSDTS and then multiple Instances would each have their own set of disks for Data, Logs, Tempdb, etc.

here is how I see the steps to install a Default Instance.

1) Setup 'New SQL Server Failover Cluster Installation" on Node 1
2) Go to the second Node (without failing over) and run set 'Add Node to a SQL Server failover
Cluster'

I should now have a fully functioning 2 Node Active Passive Cluster with a Default Instance.

---
For each SQL Server Instance that I want to add, would I repeat steps one AND two?



Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19810 Visits: 17242
Jpotucek (9/12/2012)
one last point for clarification?? Blush

tut tut tut, any more of this and you'll be incurring fees :-D



Jpotucek (9/12/2012)
So (if I have this straight) There is one Quorum and one MSDTS and then multiple Instances would each have their own set of disks for Data, Logs, Tempdb, etc.

With Windows 2008 you can have more than 1 clustered MSDTC, but essentially yes, you are right



Jpotucek (9/12/2012)
here is how I see the steps to install a Default Instance.

1) Setup 'New SQL Server Failover Cluster Installation" on Node 1
2) Go to the second Node (without failing over) and run set 'Add Node to a SQL Server failover
Cluster'

I should now have a fully functioning 2 Node Active Passive Cluster with a Default Instance.

What do you need me for? ;-)




Jpotucek (9/12/2012)
For each SQL Server Instance that I want to add, would I repeat steps one AND two?

yes, that's correct.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Jpotucek
Jpotucek
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1552 Visits: 1677
it's just so different from 2005 that the more I read .... I keep second guessing myself

Thank you again for your patient guidance!!!



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search