• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1702
  • Last Modified:

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!
0
crishna1
Asked:
crishna1
  • 6
  • 5
2 Solutions
 
chapmandewCommented:
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
 
chapmandewCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now