Recommended Config for SQL 2005 Dual server Setup | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Recommended Config for SQL 2005 Dual server Setup

I currently have one Sql 2005 Standard server, and I have ordered a second server. The first server is a dual-CPU woodcrest server with 8gb of RAM, and one hard drive. (I will get a 2nd hard drive once the new server is operational so I wno’t have any down time). This server is performing about 800-900 trans/second right now. The new server will be a Clovertown dual-CPU quad-core system with 8gb of RAM, a RAID-1 15K drive config , and a RAID-10 8 disk 300gb 10K drive config. What is the best way to setup these two servers to operate in conjunction w/ each other? I’ll be replicating the databases between the two servers, so would a cluster make sense? Thanks,
Joe
If you trying to use both individual servers either replication or database mirroring is the best option… YOu can go with cluster but you have to have storage solution so that disk can be configured to see by both servers…. MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Cluster is required a certified hardware and similar configuration, if you are looking for high availability solution then Database mirroring can help in this regard. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Clustering is a high availability solution However if you are looking at maintaining a standby system(server/database) then think of Logshipping/Replication/Database mirroring. Girish Patil
MS-SQL DBA
http://www.facebook.com/p/Girish_Patil/517990969
*** This posting is provided AS IS with no rights for the sake of knowledge sharing. ***
Even database mirroring is also another high availability option with lesser hassle than clustering. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Every solution has its own pros and cons…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>