Questions tagged [activity-monitor]

Activity Monitor is a Microsoft SQL Server utility. Use this tag for questions about how to use, understand, or diagnose problems with Activity Monitor. For non-Microsoft SQL Server questions, use the "monitoring" tag.

7
votes
1answer
265 views

.NET executes a SQL query and Active Monitor shows multiple rows blocking each other

I use .NET to execute SQL operations on SQL Server 2014, here's the code used: using(SqlConnection conn = new SqlConnection(connectionString)){ //https://stackoverflow.com/questions/1880471/...
4
votes
1answer
124 views

SQL Server 2014 View any Live execution plan in Activity Monitor

I have a SQL Server 2014 Build(12.0.5205.0) running here. Would It be possible to view any Live execution plan (from queries being executed by other users) in Activity Monitor ? My problem is: ...
2
votes
3answers
76 views

SQL Query to find the location of the running query?

I am trying to get the information about the running queries for query performance monitoring purpose. Is there a way to get the location of the running query in SQL-server? For instance, if I have a ...
1
vote
1answer
43 views

Does using Activity Monitor have an effect on server performance?

Our SQL Server VLDB is being monitored by Activity Monitor on a networked machine. 95% of all traced statements can be attributed to this tool, but is it known to have a negative effect on server/...
0
votes
2answers
133 views

Monitoring blocking queries in SQL Server 2012 [closed]

have to monitor blocking queries in SQL Server 2012. How do we figure out which queries are the locked ones? Do I use the Activity Monitor? I want actual SQL statements.
1
vote
1answer
2k views

Activity Monitor (SSMS) timeout error on Sql server instance

Environment: Window server 2012R2: RAM = 4GB Sql Server 2008R2: Min server memory = 0MB Max server memory = 2147483647MB Background of problem: I am managing database of asp.net application and ...
3
votes
2answers
597 views

tsql Process running forever… what is it doing

Trying to create a big test DB, I have an SP that I created that uses a predefined list of tables (35 That I'm interested in) and multiplies the data in each one of them. In other words, A table ...
6
votes
3answers
13k views

How to get the SQL Server Activity Monitor's output using T-SQL?

Is there any script to get the output just like Activity Monitor? Or Which DMV's can I use to get the output as Activity Monitor displays on the screen? It should be able to display the stored ...
4
votes
2answers
613 views

Why is the processor % different in Activity Monitor vs Resource Monitor?

I'm tracking a significant difference between the processor % reported in the Activity Monitor for SQL Server vs the total processor % used in the Resource Monitor. I'm seeing about a 50% difference ...
0
votes
1answer
1k views

Activity Monitor % Processor Time grayed out on SQL Server

The % Processor Time graph at Activity Monitor for remote connections stopped working and it grayed out after the physical SQL Server restart (image below), but when I get in the server with the same ...
2
votes
1answer
57 views

How is Activity Monitor Pulling processes specific memory information?

How is SQL Server Management Studio's Activity Monitor pulling the following memory by processes information? The screen I am talking about is... Log into the database, right click on the server in ...
8
votes
1answer
19k views

What is the SQLCLR wait type in Activity Monitor within SQL Server Management Studio (SSMS)?

When I check our SQL Prod server, every time I open Activity Monitor I always see SQLCLR on the first list on the resource wait section in the Activity Monitor. It always has a high number. What is ...
4
votes
2answers
3k views

Users running expensive queries

I am currently monitoring the expensive queries from the activity monitor for SQL server. How do I see who is running the different queries?
3
votes
2answers
1k views

Parameters in Activity Monitor

To view "recent expensive queries" I use Activity Monitor. Some of the queries there are with parameters. Is there a way to know the values?
0
votes
1answer
84 views

SQL Server - Check for opened Activity Monitor

I'm looking for a way to send an alert when a DBA tool is connected for "too long" on a SQL Server Production database. For most of the tools I listed out, I can find the program name with the ...
3
votes
1answer
8k views

Permanent count of waiting tasks (2) in Activity monitor

Now I'm observing in Activity Monitor permanent count of waiting tasks: and at "Resource waits" tab I see next: so, my question is: How to find and resolve this wait tasks? I suspect that it ...
5
votes
2answers
17k views

How to track DML and DDL daily events

I have the following query to track what tables are modified in the current date: SELECT TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, TIMESTAMP AS `...
1
vote
1answer
18k views

why a session becomes a head blocker

I am troubleshooting a problem that seems to be random The problem is sometimes an application (dynamics SL) is freezing When the application is freezing , I notice there is a blocked by in SQL ...
6
votes
3answers
452 views

Check server activity with code

I would like to see the activity on of the SQL server. So I can run a query when the server load is low. I know there is an activity monitor in SQL server but my company doesn't want me to give the ...
4
votes
1answer
3k views

Exporting SQL Server 2008 R2 Activity Monitor Log

In SQL Server 2008 R2, admin users are allowed to view the Activity Monitor and under "Recent Expensive Queries", there is a list of SQL statements being ran on the server. Is there a way to export ...
6
votes
1answer
25k views

SQL Server Activity Monitor - Resource Waits - Logging > 1400 ms/sec, how?

I have an SQL Server 2008 R2 server. I open "Activity Monitor", and inside the "Resource Waits" category, I see that the "Logging" category is taking up more than 1400 ms/sec. That doesn't seem to be ...
2
votes
1answer
531 views

Resource Waits: Mathematical link between Wait Time and Average Waiter Count

Just curious, per BOL Wait Time (ms/sec) is the wait time in milliseconds for all tasks waiting for one or more resources in the category since last update. Average Waiter Count is the number of ...