activity-monitor Archives

SQL Query to find the location of the running query?

By adminPosted on January 21, 2023

Question : I am trying to get the information about the running queries for query performance monitoring purpose. Is there […]

By adminPosted on January 6, 2023

Question : I have a SQL Server 2014 Build(12.0.5205.0) running here. Would It be possible to view any Live execution […]

By adminPosted on July 10, 2022

Question : I have the following query to track what tables are modified in the current date: SELECT TABLE_OWNER, TABLE_NAME, […]

By adminPosted on June 11, 2022

Question : In SQL Server 2008 R2, admin users are allowed to view the Activity Monitor and under “Recent Expensive […]

By adminPosted on April 26, 2022

Question : I am trying to get the information about the running queries for query performance monitoring purpose. Is there […]

By adminPosted on April 10, 2022

Question : I am trying to get the information about the running queries for query performance monitoring purpose. Is there […]

By adminPosted on March 4, 2022

Question : Trying to create a big test DB, I have an SP that I created that uses a predefined […]

By adminPosted on December 28, 2021

Question : When I check our SQL Prod server, every time I open Activity Monitor I always see SQLCLR on […]

By adminPosted on September 17, 2021

Question : To view “recent expensive queries” I use Activity Monitor. Some of the queries there are with parameters. Is […]

By adminPosted on May 25, 2021

Question : I have an SQL Server 2008 R2 server. I open “Activity Monitor”, and inside the “Resource Waits” category, […]