Stastistics were invalidated when you upgraded to SQL 2005, so you need to
run sp_updatstats.
If that does not help, you need to analyse more closely what is slow. It's
possible that the optimizer makes a different decision for some queries to
the worse.
Also, I would recommend that you try running the database in
compatibility level 90. If you restored the database and did nothing
more, it is in level 80. This is not likely to affect performance, but
it may prevent you from using new features in SQL 2005 later on. On
the other hand, there may be compatibility issues causing your queries
to fail in level 90. You can switch back to 80 if this happens.
run sp_updatstats.
If that does not help, you need to analyse more closely what is slow. It's
possible that the optimizer makes a different decision for some queries to
the worse.
Also, I would recommend that you try running the database in
compatibility level 90. If you restored the database and did nothing
more, it is in level 80. This is not likely to affect performance, but
it may prevent you from using new features in SQL 2005 later on. On
the other hand, there may be compatibility issues causing your queries
to fail in level 90. You can switch back to 80 if this happens.
Comments