Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicromonicon
Starting Member
8 Posts |
 Posted - 2010-02-23 : 05:00:24
|
Hello, so i migrated my database from 2000 to 2008, i had performance issues so i ran this recipeStage I DBCC UPDATEUSAGE UPDATE STATISTICS (with FULL scan) for all tables exec sp_recompile for all objects exec sp_refreshview for all viewsStage II EXEC [sp_MSforeachtable] @command1="DBCC DBREINDEX('?')" exec sp_recompile for all objects exec sp_refreshview for all viewsperformance is great, but there are deadlocks now.notice i also ran the same steps on my sql 2000 database...and there's no deadlocks.your help is much appreciated  |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-23 : 05:08:51
|
| Did you change compatibility mode?Here are suggested steps for migration to SQL 2008 (much the same as you have done, but you may spot something different / additional, plus there are suggestions for extra security for detection of corruptions etc)http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230Presumably the query plan has changed for something. You could spent time hunting that down or, if it turns out to be related to Reads on the tables, then turning on READ_COMMITTED_SNAPSHOT may be all you need to do. |
 |
|
|
|
|
|
deadlock after migration