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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-01 : 15:02:06
|
| Maan writes "We've running our web application for almost two years now and there has been no problem, only last friday that we started encountering deadlock problems. We've just transferred the database from another server and it has been running for a month already when the deadlock problem started. What could've possibly happened?" |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-01 : 16:03:27
|
| Have you run a DBCC CHECKDB on the database? Could be that you're seeing h/w problem on the new server leading to deadlocks (quite a common problem when corruption occurs).Also, where are the deadlocks occuring? Do you have any deadlock output from the errorlog you can share?ThanksPaul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-01 : 16:04:30
|
| have you applied SQL 2K SP4?-ec |
|
|
|
|
|
|
SQL Deadlock