Tracing Lock:Timeout in SQL Server
Posted on 2008-06-10
I have a trace file for LOCKS on a database, but i need to see the data under TextData event as well to see which sql is being executed during the Lock:timeout event. is it true that if i trace for the Locks?
Basixally i need to trace if there are any locks occuring and which SQL is being executed during the locking and by which application/login.
Also, i see
"Microsft(R) Windows (R) 2000 Operating System" and
".Net sqlClient Data Provider"
under the ApplicationName for an EventClass Lock:Timeout.
What does does this really mean? is it the OS and Client being used by whatever aapplication is running on?