Using multiple instances on a cluster.

  • Hi,

    Is anyone running multiple instances in a clustered environment on windows 2000?

    I am looking at consolidating a number of small databases onto an exisiting sql2000 clustered instance using a HP EVA SAN. At this stage i am looking to add an additional 1-3 instances.

    Are there any 'Real world' gotchas to be aware of?

    Understand that each instance needs its own disks, specifically its own LUN.

    Just found a great book called "Microsoft SQL Server 2000 Availability"

    that is good reading.

    Regards, Brian

  • We have Active\Active clusters in inventory. The main catch is to plan to hardware to handle the memory requirements should all instances fail to 1 node. Enough processing power, etc. especially if you're going into AWE memory. In that case there are a few whitepapers and KB articles that deal with this subject because there are some planning steps you'll need to take care of.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

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