Skip to main content

See the actual query used by a process



SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time,
req.user_id,
req.reads,
s.login_name
FROM sys.dm_exec_requests req
inner join sys.dm_exec_sessions s
       on req.session_id = s.session_id 
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

Comments

Post a Comment

Popular posts from this blog

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more