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 |
|
jooorj
Posting Yak Master
126 Posts |
 Posted - 2011-07-07 : 06:15:24
|
| I need A script to view all deadlock process |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-07 : 06:26:14
|
| You mean you want to view the results of sql server terminating a process due to a deadlock?You can set trace flags to log info and view the log.Not really sure what the question is - have you tried a search for sql server deadlock?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-07 : 06:46:35
|
| There's no simple script. SQL doesn't store historical deadlock unless you ask it to.Traceflag 1222 causes SQL to write deadlock graphs into the error log. You can run a server-side trace with the deadlock graph event. I'm pretty sure there's an extended event, but I'm not familiar with those.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
I need A script to view all deadlock process