How to consolidate 6 sqlservers to a 2-node cluste | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to consolidate 6 sqlservers to a 2-node cluste

I currently have to define the hardware-needs to consolidate 6 win2000 sql2000 sqlservers (5 oltp/ 1 olap) to a 2-node cluster environment. (total start capacity 200Gb affective data expected to extend the olap part from 1 year of data to as much the drives (san) can take.) I hope to be able to implement 64-bit (SS2005) with this occasion, but for that I have to deliver a TCO/ROI kind of report. I currently started some perfmon en profiler traces to gather the numbers. Do you have any templates, guidelines to handle these kind of requests ? [?]
To implement full level of clustering with SQL 2005 you have to wait until end of next month, in this case you try contacting MS support or MS newsgroups for any resolution. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Satya,<br />Thanks for the quick response [8D]<br /><br />I know ss2005 only ships next month. <br />But preparation, planning and implementation do need some time [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br />For the moment it’s kind of a struggle to get everything lined up so this challange can be accomplished with a clear view regarding steps, procedures and nilestones.<br /><br />SS2005 is kind of mandatory for this case because of the internal client’s prerequisits. They want to be able to use this environment for the next 5 years up to the most that the marked brings today. Even if that means having a 1.0 product (ss2005 / biztalk2006 with vs2005 and .net2.0) [B)]<br />
See if this helps:http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9202 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
I suggest contact Microsoft in this case for your project as a case study for them. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks for all advices
]]>