| Author |
Topic |
|
Pace
Constraint Violating Yak Guru
264 Posts |
 Posted - 2007-12-11 : 10:42:32
|
Hi, I am looking for information, sample code to help me debug some record locking issues I am getting with a particular table. Any links/advice greatly appreciated. pace  "Impossible is Nothing"  |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-11 : 11:00:32
|
| Use SQL Profiler to find what procedures/code is causing the locks in the first place. If you can (depending on your data), use nolocks or read uncommited trasaction levels. |
 |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2007-12-11 : 11:21:18
|
| Hi yeah ive been looking at profiler, but I only want to record locks... when im trying to set up a trace, its recording all actions, which is a lot to sift through to find when the lock was. I was hoping someone maybe had a template? or a link to where I could read up and obtain some code about viewing only these locking events. Its something I would really like to solve, plus im hoping it will help me with my mcts course. Any ideas?"Impossible is Nothing" |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-11 : 11:44:35
|
| what kind of locking?deadlocks, blocking to to escalation, conversion locking blocking, ...?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2007-12-11 : 11:46:57
|
| blimey, thats a printer job me thinks. Some serious reading there. Skimmed through, looks like it could be just what im looking for, thanks RickD, anyone else feel free to add if you can. cheers"Impossible is Nothing" |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2007-12-11 : 11:53:41
|
| sorry, deadlocking is my issue. I wasnt aware of the others :S lots to learn"Impossible is Nothing" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
Troubleshooting Locking