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.

learn more… | top users | synonyms

2
votes
1answer
18 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 ...
3
votes
1answer
116 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
202 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?
1
vote
2answers
125 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
31 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 ...
1
vote
1answer
2k 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
1k 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
0answers
74 views

Average Waiter Count increasing

I am in a nightmare. We have deployed an application to a UAT environment, which has only 7 users. Since then, we have noticed in the logs, a lot of deadlocks, and processes being victims and things. ...
1
vote
1answer
6k 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
280 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
2k 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 ...
4
votes
1answer
16k 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
407 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 ...