Post reply

Failover Clustering

  • May 9, 2003 at 2:02 pm

    #456730

    Hehehe, I'm not a big fan of partitioned views, either. You also have to consider that for it to work efficiently you have to be able to segment your data somewhat uniformly and that's not always possible. However, it's out there as a possibility.

    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

  • May 9, 2003 at 2:34 pm

    #456735

    thanks for mentioning the segmenting issue as well. I have worked in partitioned db environments in SQL 7.0 in a web based multimedia company. Application took care of redirection. Had replication going as well for a subset of the schema and everything worked beautifully. It requires a lot of planning and the schema has to be relatively stable, not in development and changing like every month. But as you mentioned it is out there for folks to use. Appreciate the input

    -srini

  • May 22, 2003 at 11:15 am

    #458226

    Some of the limitations of Win 2K clustering should be being overcome in Win 2003. Check out http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/windowsserver2003/technologies/clustering/default.asp for details. They seem to have taken a leaf out of Veritas's book and eliminated the Quorum drive, making N plus I (how do I put in a plus char in this utility - it seems to get eaten?) clusters possible which, let's face it, is where clustering starts getting interesting - all this 2-node active/passive stuff is pretty damn feeble.

    We are currently evaluating Veritas's Clustering software vs. MSCS (the current 2K version) as there is obviously a big price incentive (VCS runs with std ed. Win & SQL - add up the licencing difference per processor for 3 or 4 duals or quads and it starts becoming serious money) but we're still too early in the process to give any firm opinions either way.

    Anybody out there have experience running both?

Viewing 3 posts - 16 through 17 (of 17 total)

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