May 9, 2003 at 2:02 pm
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
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
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