Upgraded from SQL 2000 to SQL 2005 and my database application now takes 6 times as long...

Posted on 2008-11-05
Last Modified: 2010-03-19
I have a software application that uses SQL as its backend database.  I have historically used SQL 2000 and recently upgraded to SQL 2005 because another application I was using demanded the upgrade.  The main application now takes 5-10 times longer to complete the same task as the old SQL version.  Any thoughts?  I am running both SQL and application locally on a Dell laptop with 4 gig of ram.
Question by:majervis
    LVL 142

    Accepted Solution

    did you update the statistics after the upgrade?
    can you run the queries in the query window with "include actual execution plan" to see what "happens"?
    -> post that picture, please

    Author Comment

    by:majervis do I do that? I am new to 2005 and frankly a bit of a novice anyways.
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    update statistics:

    for the second part, that should be "obvious", in the meaning that you should know how to run some query in the query windows of sql 2005 management studio, and in the Query menu, you find the "include actual execution plan".

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now