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 related with transactional replication, which running on the server. This wait tasks I see only on Distributor. This issues appeared after restarting SQL server service. sp_whoisactive - doesn't show any locks. Thanks a lot for any information.

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 Domain User it works fine. It was also working fine on remote connections before the restart and I have noticed that it takes significantly more time to load the Processes than before. The problem is happening to all users that try to see the Processor Time remotely including **sa** and server admins so I would think it´s not a permission issue. The server runs Windows Server 2012 and SQL Server 2012. What could be happening? or How can I solve this? Thanks in advance! and sorry about my English.

We are seeing an issue with not being able to open Activity monitor for remote SQL servers. The Activity Monitor is unable to execute queries against server . Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) (mscorlib) It appears some firewall is blocking it, When we look at firewall logs (on the network), we are seeing blocks from 496xx. And its different port for each server. Is anyone aware if we can make this a static port?

When I connect to my SQL Server using SQL Server Management Studio (SSMS) from a remote computer, the "% Processor Time" metric in the Activity Monitor is greyed out and unavailable. However, when I connect to the same server from SSMS installed on the local machine (where the SQL Server instance is running), the "% Processor Time" metric is visible and functioning as expected. Is this the normal behaviour of Activity monitor , If yes please provide proof for this

I am trying to understand the active expensive queries and recent expensive queries in Activity Monitor. What is expensive means here? Does it means expensive in term of cpu, block, memory, reads?

Is there a way to keep the connection history to a certain table in SQL-server? Not just the database because that's easy using the DMV's but just one particular table.

I have this strange issue on one of my DB (SQL Server 2016) in which the activity monitor display duplicates entries in recent expensive query. In the picture above you can see a snapshot (only two lines) of the Activity Monitor, that display two indentical query (same query text, same execution plan, same target DB) as it was two distinct queries instead of grouping them and incrementing the field execution/min. What is happening here? it's just an Activity Monitor glitch or should i start to check what's wrong in my DB. I am afraid that the same ORM query (executed two times by differnt request) is not recognized by DB as the same query, and istead it's considered as two different queries, that will degrading performance.

Some of our end-users still like to use the Activity Monitor in SQL Server. When setting up our SQL-server 2016 servers the activity monitor always ends up in a paused state when the users are not part of the "Administrators" group in Windows (on the server). When the users are part of the Administrator-group all data gets through (so probably not a Firewall-problem). We also tried: - Adding the users to the "Performance Monitor Users" and "Distributed COM Users" - In COM: Changing the limits of "My Computer" and the permissions on "Windows Management and Instrumentation". - The users also have the "View server state" permission in SQL Server. Do you have any other suggestions? Kind Regards, Tim

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 rights to use this tool. Apparently you can kill other people queries and this is too dangerous. Is there a way to check the status of the server with code? (Or view the activity without needing those rights so I can manually run them?)

We have executions/min is too high, around 20,000 to 30,000 for a query. Does this means the query is executing 20,000 per minute? I don't think we have that much load on server that a single query runs 20,000 per minute. Also, I am always confused with CPU ms/sec. Does this means total CPU used per second? If yes how come we have lot of queries with 1000+ CPU ms/sec as we have limited CPU on server.

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.

I am currently monitoring the expensive queries from the activity monitor for SQL server. How do I see who is running the different queries?

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 the tree on the left and select activity monitor. Expand out processes. The Memory Use column - where is it coming? Is there an internal database table that it is pulling from? I ask because I am trying to figure what all goes into this metric so I can determine if one of the processes is growing without bound or growing as expected due to design.

I use .NET to execute SQL operations on SQL Server 2014, here's the code used:

lang-cs
using(SqlConnection conn = new SqlConnection(connectionString)){
    //https://stackoverflow.com/questions/1880471/capture-stored-procedure-print-output-in-net 
    conn.InfoMessage += new SqlInfoMessageEventHandler(logSqlMessages);
    conn.Open();
    using(SqlCommand stmt = new SqlCommand{
        Connection = conn,
        CommandText = sql,
        CommandTimeout = 30000 // The time in seconds to wait for the command to execute. The default is 30 seconds.
        //,CommandType = CommandType.StoredProcedure
    })
    {
        affectedRecords = stmt.ExecuteNonQuery();
    } // using stmt
} // using conn

When I look at Active Monitor, there are tens of rows referencing the same operation. They all have the same session_id, some of them have Task State running and most of them are suspended. Some of them have LastWaitTime CXPACKET and most are PAGEIOLATCH_SH. I also ran a query on SQL Server and same behavior happened on Active Monitor. Maybe it's a normal behavior of it, but it's odd that a SELECT operation creates multiple rows and blocks itself like that. Any idea of what may be causing it?

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 procedure name as well as the statement from the stored procedure which is currently running and the bloking related info as well.

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: When I open the Activity Monitor - > Active Expensive Queries, I can see all expensive queries, but clicking right button the "Show Live execution Plan" is only enabled for queries that my user is running, for the any other user this menu is disabled: An example: I heard about Trace flags, enable a global trace flag using [DBCC traceon(7412,-1)](http://www.sqlservercentral.com/blogs/matthew-mcgiffen-dba/2017/02/23/sql-server-2016-the-coolest-new-feature-live-query-stats/) . So, my questions is: 1. Enabling This flag above (7412), considering the build version of my Sql Server, will it work? Or only in SQL Server 2016? 2. If it works, I don't have the sa rights. What kind of permissions do I have to ask for?

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 stored procedure running in a server and if I'm getting all the activity monitoring data for the running query, I want to fetch the path of the stored procedure in which the query is running. Is there a query to do this or any other way to get this path? Example Path/hierarchy : sever/db/stored_procedure_name/query

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 between the two with the Activity Monitor always being higher. System Specs: * SQL Server EE 2008 R2 * Windows 2008 R2 * Bare metal * 96 cores w/no processor affinity set (4 Physical Sockets with 12 cores each w/HyperThreading enabled) * 768 GB of memory * Active/Passive cluster * Direct attach storage of SSDs What would cause such a difference? Which one should I be looking at? Update: I see that resource monitor has it split between different categories however wouldn't the "CPU - Total" graph show all CPU usage on the machine? The Task Manager Performance tab is showing the same difference between it and Activity Monitor. * Activity Monitor is on a 1 sec refresh. Could there be an issue with Activity Monitor not seeing that each core is HyperThreaded? Not sure how as SQL Server sees all 96 cores. **Update 6/28/2018** Even after migrating to AWS and updating the OS to Server 2012 R2 the SQL Server 2008 r2 Activity Monitor is still dramatically off from what Task Manager shows. The below screen shot is from a load test that was just performed. There is a visible 20% difference between the two metrics. Even when Task Manager is reporting the overall CPU just over 55% the SQL Activity Monitor is pegged at 100%. Metrics from the AWS Cloud watch show the same results as Task Manager so I have two data metrics that correlate with a third that isn't even in the ballpark. Updated System Specs: System Specs: * SQL Server EE 2008 R2 * Windows 2012 Datacenter R2 * i3.16xl - Dedicated Host * 64 cores w/no processor affinity set (2 Sockets with 32 cores each) * 488 GB of memory * Synchronous Mirroring * ENA Enabled w/EBS Optimization enabled

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/network?

**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 recently application started to crash (when user tried to sign-in to the application; user see timeout exception on the browser). In order to rectify the issue I set **timeout =1000** in connection string of webconfig file and that resolved the issue. When application was crashing I tried to turn on the activity monitor on Sql server instance but I coudn't start activity monitor and got following error: **My finding so far:** I started my quest and troubleshooted and found that there is memory pressure but I need expert advice if there is any link of activity monitor not starting with memory pressure? I know error is from database as Sql server was busy at the time of crash. How I can further troubleshoot the problem?