Tracing Lock:Timeout in SQL Server

Dear Experts,

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?

Please help!
crishna1Asked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
Locks are always occurring in SQL Server.  If you want to see other procedures that are running at the time...select the SP:Completed event as well...also include the ObjectName in the output field list.
0
 
crishna1Author Commented:
thats true, but i am looking for anything that has Lock:Timeout and Lock:Deadlock and corresponding Textdata i.e sql.
0
 
chapmandewConnect With a Mentor Commented:
right...anything executing around the time of those errors should correspond with them.  

also, for tracking deadlocks, you can use the sqldiag tool.
http://articles.techrepublic.com.com/5100-10878_11-6116287.html
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
crishna1Author Commented:
also like i mentioned in my original question, what about these?

"Microsft(R) Windows (R) 2000 Operating System"  and
".Net sqlClient Data Provider"
0
 
chapmandewCommented:
tells you the OS and the type of connection made.
0
 
crishna1Author Commented:
they all are under the same column, Applicationname. how can it be OS and type of connection?
0
 
crishna1Author Commented:
How do get the TextData also traced while tracing for Deadlock, Timeout? see attachment.

0
 
chapmandewCommented:
I don't see an attachment...
0
 
crishna1Author Commented:
some reason i am unable to attach the file, but the question is "How do get the TextData also traced while tracing for Deadlock, Timeout?"
0
 
chapmandewCommented:
what do you mean?  are you trying to set criteria on the textdata column, or you just can't see it?
0
 
crishna1Author Commented:
yes , how to set criteria on text data column while tracing for Deadlock, Timeout?
a screen shot will be helpful , if possible.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.