SQL Server Performance

How to consolidate 6 sqlservers to a 2-node cluste

Discussion in 'SQL Server 2005 Clustering' started by alzdba, Oct 20, 2005.

  1. alzdba Member

    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 ?

    [?]

  2. satya Moderator

    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.
  3. alzdba Member

    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 />
  4. FrankKalis Moderator

  5. satya Moderator

    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.
  6. alzdba Member

    Thanks for all advices

Share This Page