Skip to content

Instantly share code, notes, and snippets.

@viniciusgati

viniciusgati/query.sql

Created July 14, 2020 12:40
Show Gist options
  • Save viniciusgati/4fbb5bcecbaa09a434c6dd2c67b4503e to your computer and use it in GitHub Desktop.
Save viniciusgati/4fbb5bcecbaa09a434c6dd2c67b4503e to your computer and use it in GitHub Desktop.
Download ZIP
queries em execução SQL Server
Raw
query.sql
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment