Post reply

Performance advice

  • September 8, 2006 at 8:14 am

    #367315

    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

    #659478

    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