Clustering SQL

Clustering SQL

Post by Peter Down » Thu, 16 Dec 2004 11:09:37


Are there any major issues in clustering SQL 2000 on a Windows 2003 cluster?

Will with is also be fine for SQL 2005 on a Windows 2003 cluster?
 
 
 

Clustering SQL

Post by Linchi She » Thu, 16 Dec 2004 12:16:47

 
 
 

Clustering SQL

Post by Peter Down » Thu, 16 Dec 2004 12:27:00

Are there huge performance benfits in clustering SQL? Would a second
identical server in a cluster double the performance?
 
 
 

Clustering SQL

Post by Rodney R. » Thu, 16 Dec 2004 12:33:46

I would add that you need to do 817064 BEFORE 301600 :)

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.yqcomputer.com/ - Clustering
http://www.yqcomputer.com/
 
 
 

Clustering SQL

Post by Rodney R. » Thu, 16 Dec 2004 12:35:28

A database; or an instance of SQL for that matter, will only run on one
server at a time - clustered or not. You can not load balance SQL databases
across servers.

The benefit to clustering SQL is High Availability. Oh, and its really cool.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.yqcomputer.com/ - Clustering
http://www.yqcomputer.com/
 
 
 

Clustering SQL

Post by Peter Down » Thu, 16 Dec 2004 14:35:39

Thanks for the advice!

"Rodney R. Fournier [MVP]" < XXXX@XXXXX.COM > wrote in