|
We have just done an inline upgrade of SQL 2000 to SQL 2005. Since this upgrade we have noticed a performance decrease in some applications. I noticed that all database files have a compatibility level of SQL 2000. Would we get improved performance if we change this to be SQL 2005? Cheers Brad
(comments are locked)
|
|
..and you should rebuild your indexes. But before jumping up the compat level, test, test, test!
(comments are locked)
|
|
You should also refresh your statistics after an upgrade: sp_updatestats.
(comments are locked)
|
|
before executing sp_updatestats, make sure you run dbcc updateusage({databasename|id}) in order to fix inaccuracy in this particular database. Note: You need to do this only once.
(comments are locked)
|
|
Perhaps. Hard to say. You might also find that some things break. I would definitely encourage you to put your compatibility level up, but do it on a test server first and make sure things are okay.
(comments are locked)
|
