SQL Server Running Queries Monitoring

Hi,

SQL Server DBA should monitor database and running queries everytime.

To monitor running queries are very important for performance tuning criteria. Because if any query is running long time then you can warn application owner or customer. And you can ask yourself and customer why this query is running long time, is it normal or not ?

You can monitor running queries in SQL Server with following script.

select text, 
SUBSTRING(st.text, (qs.statement_start_offset/2)+1, 
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(st.text)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2) + 1) AS statement_text,
* from sys.dm_exec_requests qs
cross apply sys.dm_exec_sql_text(sql_handle) st
cross apply sys.dm_exec_query_plan(plan_handle);

Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.

https://ittutorial.org/sql-server-tutorials-microsoft-database-for-beginners/