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 |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2010-07-25 : 14:38:38
|
| A few weeks ago we upgraded our SQL Server to 2008 from 2005. Nothing else changed. Since the upgrade an intensive process that runs every 15 minutes has been deadlocking about once per day. This never happened when on 2005. Has anyone experienced increased deadlocks with 2008? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-26 : 02:45:53
|
| Dunno about difference between 005 and 2008 but you might want to look at READ_COMMITED_SNAPSHOT if you have Reads blocking Writes and you are not already using it. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-26 : 04:24:19
|
| Rebuild all your indexes?--Gail ShawSQL Server MVP |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-26 : 04:29:04
|
| Ah ... well if they didn't do that then there might be some things worth the O/P looking at in this thread:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 |
|
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
|
|
|
|
|
Deadlocks in 2008 compared with 2005