Currently running queries in SQL Server

Question

Is there a program or a sql query that I can find which SQL queries are being run on an SQL Server 2012  I think there was a tool in earlier version of SQL Server where the actual query content gets displayed or the stored procedure name

User · Answer

Depending on your privileges  this query might work   SELECT sqltext TEXT  req session id  req status  req command  req cpu time  req total elapsed time FROM sys dm exec requests req CROSS APPLY sys dm exec sql text sql handle  AS sqltext   Ref  http   blog sqlauthority com 2009 01 07 sql-server-find-currently-running-query-t-sql

User · Answer

here is what you need to install the SQL profiler http   msdn microsoft com en-us library bb500441 aspx  However  i would suggest you to read through this one http   blog sqlauthority com 2009 08 03 sql-server-introduction-to-sql-server-2008-profiler-2   if you are looking to do it on your Production Environment  There is another better way to look at the queries watch this one and see if it helps http   www youtube com watch v vvziPI5OQyE

User · Answer

I use the below query   SELECT   SPID         er session id      STATUS           ses STATUS       Login           ses login name      Host             ses host name      BlkBy            er blocking session id      DBName           DB Name er database id       CommandType      er command      ObjectName       OBJECT NAME st objectid       CPUTime          er cpu time      StartTime        er start time      TimeElapsed      CAST GETDATE   - er start time AS TIME       SQLStatement     st text FROM    sys dm exec requests er     OUTER APPLY sys dm exec sql text er sql handle  st     LEFT JOIN sys dm exec sessions ses     ON ses session id   er session id LEFT JOIN sys dm exec connections con     ON con session id   ses session id WHERE   st text IS NOT NULL

User · Answer

There s this  from SQL Server DMV s In Action book   The output shows the spid  process identifier   the ecid  this is similar to a thread within the same spid and is useful for identifying queries running in parallel   the user running the SQL  the status  whether the SQL is running or waiting   the wait status  why it   s waiting   the hostname  the domain name  and the start time  useful for determining how long the batch has been running    The nice part is the query and parent query   That shows  for example  a stored proc as the parent and the query within the stored proc that is running   It has been very handy for me   I hope this helps someone else   USE master GO SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT er session Id AS  Spid    sp ecid   er start time   DATEDIFF SS er start time GETDATE    as  Age Seconds    sp nt username   er status   er wait type   SUBSTRING  qt text   er statement start offset 2    1    CASE WHEN er statement end offset   -1 THEN LEN CONVERT NVARCHAR MAX   qt text     2 ELSE er statement end offset END - er statement start offset  2    1  AS  Individual Query    qt text AS  Parent Query    sp program name   sp Hostname   sp nt domain   FROM sys dm exec requests er INNER JOIN sys sysprocesses sp ON er session id   sp spid CROSS APPLY sys dm exec sql text er sql handle as qt WHERE session Id  gt  50 AND session Id NOT IN    SPID  ORDER BY session Id  ecid

User · Answer

You are talking about SQL Profiler

User · Answer

The tool is called the SQL Server Profiler  it s still part of the standard toolset

[sql] Currently running queries in SQL Server

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008