September 8, 2006 at 8:14 am
My company's web application runs on a web farm talking to SQL2k databases. We have reached a point where the application won't scale too much more. As an interim solution it has been suggested that we move the 8 databases we currently have into one database and upgrade to SQL 2005. The reason for this move is to cut down on a perceived overhead of doing cross database joins. Does anyone know if moving to one database will offer any noticeable performance improvement and will SQL2005 help too?
Thanks for any suggestions.
September 8, 2006 at 3:58 pm
I doubt this would bring you much. My experience is that cross database joins are fairly cheap. It's the cross-server joins that kill you.
I would suggest profiling the database server and seeing where the real bottlenecks are, rather than pursuing a course based on a "perceived" bottleneck. Find the queries that are bogging down, then look at the execution plans to make sure they are reasonable.
---------------------------------------
elsasoft.org
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply