SQL Server Performance

Performance with SQL2005 db migrated to SQL2008

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by GMason, Jun 28, 2009.

  1. GMason New Member

    We have just moved our 2005 databases to 2008.
    One query is giving us a problem. Its taking a lot longer to execute.. and has gone from seconds to hours. Nothing has changed in the database. The wierd thing is that it runs fine on a different test system also with 2008 installed. The difference between the the test system is that it has 16 CPU's (4cores x 4CPU) whereas the production machine only has 8 CPU's (4 CPU's x 2 cores). The production machine is exactly the same machine as before, we just flattened it and put on Win2k8 and SQL2008; and the same query was working fine on it.
    One interesting difference is that when displaying the execution plan, we see parallelism occuring on the pre-upgraded prod box, and on the test box, but not on the new prod box. Parallelism options are set to default on all machines.
    Any clues as to where to look to track this down.
  2. Sandy New Member

  3. RickNZ New Member

    Are the two systems running the same edition of SQL and Win 2008? Do they have the same amount of RAM? Same/similar disk subsystems?
    Are you running in SQL 2005 compatibility mode, or have you enabled 2008 mode?

Share This Page