September 16, 2013 at 5:33 am
Query to check Lock occurance--
Need a SQl query which can show the details colums as below
Columns Names -
dd:hh:mm:ss:mss
session_id
sql_text
login_name
wait_info
cpu
etc
Please let us know how to provide the complete query text which causes locks & which takes long time to execute??
************************************
Every Dog has a Tail !!!!! :-D
September 16, 2013 at 7:07 am
Most, if not all of that you should be able to get from sys.dm_exec_sessions, sys.dm_exec_requests and/or sys.dm_os_waiting_tasks.
Have a go through those DMVs, if you can't get something as you want it, ask here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy