clustering sqlserver 2008

Question

Post reply

clustering sqlserver 2008

vamshikrishnaeee

SSCrazy

Points: 2519
More actions
May 30, 2011 at 11:13 pm

#389622

Hi,
We are planning to cluster sqlserver 2008. My question is can't we cluster sqlserver 2008 without clusetering windows server 2003.
Thanks,
Vamsy

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

crazy4sql SSCoach Points: 19590 More actions · Answer 1

Cluster is not the sql functionality which windows used, its windows functinality which SQL server use.

----------
Ashish

vamshikrishnaeee SSCrazy Points: 2519 More actions · Answer 2

Thanks for your reply...

We are planning to do sqlserver cluster installation. So for this We need to cluster the windows server and then perform sqlserver cluster installation on it.Right!

I have few questions on this.

1. Is Cluster disk which will be shown while installing sqlserver is different from the disk on which we create database data and log files? or they are the same.

I thought of having 3 shared drives one for database datafiles, one database log files and the other for temp. So in total 3 clustered drives is enough for me or do I need more number drives?

2. Virtual IP: Is it a new IP other than two nodes IPs which are participating in the windows clustering?

3.MSDTC: Is MSDTC installation mandatory? I heard that no need to cluster MSDTC in windows server 2008 but I am not sure whether it has to be installed or not? If we need to install, do we need to install on the local disk, on which sqlserver binaries are installed?

Thanks in advance..

Vamsy

crazy4sql SSCoach Points: 19590 More actions · Answer 3

So for this We need to cluster the windows server and then perform sqlserver cluster installation on it.Right!

Correct

1. Is Cluster disk ..............

For the rest of your question, please familiarise yourself first about windows cluster and why it is requried and how it is used via sql server.

If you want then you can have a read of these articles :-

http://www.mssqltips.com/tip.asp?tip=1687

Google

----------
Ashish

vamshikrishnaeee SSCrazy Points: 2519 More actions · Answer 4

I have gone through these blogs but unable to find the answers..Can you please answer my questions if possible.

Thanks for your responses..

Vamsy

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 5

there is no any SQL Cluster,In the installation of SQL Server Cluster,it use the windows cluster,so you will create first Windows cluster and then install the SQL Server on Cluster mode

In the Windows Cluster,you have required these stuff

1-Qurum

1-MSDTC

-SQL Server Drives(as you want and required)

these drives must be create on windows cluster then its all depend upon you,how much drives you will include in the SQL Server resource group to use the sql server for different operations

1-Data File

1-Log File

1-TempDB

But my recommendation is if your database have more than 100 concurrent users

2-Data

2-Index

2-Log

1-Tempdb

How much users you have ?

What about the size of database ?

SAN storage ?

Total Physical and Logical Processors ?

Total RAM ?

RAID level ?

My Blog
www.aureus-salah.com

vamshikrishnaeee SSCrazy Points: 2519 More actions · Answer 6

Thanks for your response Syed..

1-Qurum

1-MSDTC

-SQL Server Drives(as you want and required)

Does these require separate drives or can we have all these on a same drive?

I have seen in many blogs that it good to have MSDTC and sqlserver on seperate drives.but what about quorum drive? will it be on a seperate drive?

How much users you have ? around 200 users

What about the size of database ? 20GB now

SAN storage ? ISCSI DELL PS6000XV SAN.

Total Physical and Logical Processors ? 16 logical cpu's and 4 physical cpu's.

Total RAM ? 50 GB

RAID level ? RAID 10.

Thanks,

Vamsy

Patrick Flynn-384931 SSC-Addicted Points: 449 More actions · Answer 7

Hi Vamsy

If you need to understand/set up clustering then some of the best places to start are:

Allan Hirt's Website - http://www.sqlha.com

Allan Hirt's Book - Pro SQL Server 2008 Failover Clustering

There are also some good free videos that will explain Clustering

(a) - From the SQL Server Microsoft Certified Master videos (By MCM Brent Ozar)

http://technet.microsoft.com/en-us/sqlserver/gg508898.aspx

http://technet.microsoft.com/en-us/sqlserver/gg545011

(b) From the SQLBits website

http://sqlbits.com/Sessions/Event8/SQL_Server_Clustering_for_Dummies

These will explain both "What?" and "Why" in regards to Clustering

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 8

you should define separately Qurum and MSDTC then you can define 1 Disk for all SQL Server operations now total drives needed

1-Qurum 512MB

1-MSDTC 512MB

1-SQL Server it will depend on the SQL Server Binaries,Tempdb,errorlogs,system databases and user databases

My Blog
www.aureus-salah.com

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 9

I'm curious why you are using Win 2003?

Although I didn't notice how many nodes you are looking at but SQL 2008 Standard can be installed on a 2 node cluster without having to spend $$$ on enterprise edition. But no matter what the IS has to be enterprise, clustering is not offered in the other editions.

As a second question why SQL 2008 and not 2008R2?

CEWII