April 19, 2002 at 4:12 am
Hi all
Is it possible to retrieve the isolation level a process
has set? i cant see it in sysprocesses. Basically I want
to confirm the isolation levels of a variety of
transactions as they (i believe) are being set to serialisable
rather than the sqlserver default and causing some locking
issues.
Any ideas on where to look?
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
April 19, 2002 at 5:42 am
I am not aware a process that can tell you if the isolation was change. You can look at sp_lock at the type of lock. Or if this is being changed a set should be issued. Look at using profiler to catch it during times when it usually occurrs. Most likely it is the order in which resources are accessed and a blocking issue starts when one hits a spot the other has locked and vice versa.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 22, 2002 at 3:13 am
thanks for the feedback, the code is from an app we purchased. i can get some idea from the types of locks taken out but would love to confirm my beliefs. Ill keep looking.
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply