.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

What does Suspended in Activity monitor mean

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :


SQK Server 2008 R2

Looking at a task in activity monitor. It is suspended. I understand is still has work to do and is waiting on a wait reasource.

Does that mean it will resume or has it stopped?



View Complete Post

More Related Resource Links

A Simple XML-driven Tool: Monitor Your Web Site's Activity with COM and Active Scripting


This article describes a simple Web site monitoring tool built with XML, JScript, Windows Script Host, and COM objects. Although it is not intended to replace complete Web site monitoring software products, it has many useful features that help to keep Web servers up and running. An XML configuration file specifies which Web sites to monitor and the actions to be taken if the site isn't functioning properly. In addition, the tool can be scheduled to run at any specified interval using the Windows Task Scheduler. Functions that probe the sites, log events, and send e-mail notifications are written in JScript.

Panos Kougiouris

MSDN Magazine July 2000

SQL Server 2008 - Job Activity Monitor Failing

I recently began migrating to Windows 2008. One of the first servers is a server which we install our tools on. This is a new server which currently is only running the SQL Server management tools. On this server I installed the SQL Server 2008 R2 management tools, prior to this install there were no other SQL Server tools installed on this server. The majority of the functionality works and I can connect and manage multiple databases servers from SQL Server version 2000 through 2008. But when I try to bring up the Job Activity monitor I get an error ==> Can not show requested dialog. From Windows XP Windows Server 2003 SP2 this functionality works. I get this error if I connect to a SQL Server 2005 or 2008 database instance. I have tried re-installing the client tools but I still get this error..... any ideas?

Execution Plan in Activity Monitor (Recent Expensive queries)

If we see the execution plan of a query in Activity Monitor > Recent Expensive Queries is it Estimated Execution Plan or Actual Execution Plan ?

SSMS 2008 & Activity Monitor's Processor Time graph is disabled

Hi,I just upgraded one of my SQL 2005 clusters to SQL 2008 with CU9.  Now, when I connect to it with SSMS, either from my workstation or directly on a cluster node, the % Processor Time graph in the Activity Monitor screen is disabled.  The other three graphs are fine.  If I connect to a different SQL 2008 server, the % Processor Graph is fine.  I don't see any errors in any app event log.  Has anyone else seen this behavior?Thanks!

SSMS 2008 Activity Monitor Activity Monitor is unable to execute queries against server (SQL Server

I get the following error when running SQL Server SSMS 2008 (32-bit) on my (Windows 7 64-bit) workstation against our SQL Server 2005 (32-bit) development server running Windows Server 2003 (32-bit): TITLE: Microsoft SQL Server Management Studio ------------------------------ The Activity Monitor is unable to execute queries against server <my server\instance name>. 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. ------------------------------ ADDITIONAL INFORMATION: Unable to find SQL Server process ID 2256 on server VTX-DEV-01 (Microsoft.SqlServer.Management.ResourceMonitoring)   I can expand the panes and all display data except Overview and Data File I/O. This is true for all instances on that server. The SSMS 2005 Activity Monitor (also on my workstation) works fine when connected to that server. I checked for the registry setting to disable the performance counters on both my machine and the server, and it was not there. I started the Performance Counter DLL Host on my machine, but that made no difference. I can see all Processor counters on the server from my local Performance Monitor. I ran "lodctr /R" on both systems, but that didn't help. The only SQL counters I see on the server (from my workstation) are SQLServer:SSIS Pipeline and SQLServer:SSIS

sql Server 2008: duplicated rows in Activity monitor

There are identical notes (Session id, Login etc.) in a Processes tab of Activity Monitor. Usially it is two, sometimes three same rows. Does anyone have a similar situation? Is this a bug or it is just s/th wrong in my comp? (SQL Server 2008 R2 CUP3)

minimum permissions to run sp_who2, queries against dm views and activity monitor

Hi.  I'm trying to explain some suspended tasks that could be tied to blocks on a remote server source.  I want just enough permissions to run sp_who2, activity ssms monitor and the data mgt view query you see below.  What permission should I request minimally to do this?  We're on STD 2008. SELECT *,   SUBSTRING(st.text, (r.statement_start_offset/2)+1,   ((CASE r.statement_end_offset   WHEN -1 THEN DATALENGTH(st.text)   ELSE r.statement_end_offset   END - r.statement_start_offset)/2) + 1) AS statement_text FROM sys.dm_exec_requests AS r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st     

sql 2008: the activity monitor is unable to execute queries against server

Installed sql server 2008 entrprise edition on VM server windows 2008 (64bit). When launch Activity Monitor, get:

The Acityvity Monitor is unable to execute queries against server <server name>.
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.

Additional information:
   Unable to find SQL Server process ID xxxx on server <server name>

Tried to "use he context menu in the overview pane to resume the Activity Monitor" and got the same error again.

Installed sql 2008 in my XP machine, I can use Activity Monitor (AM) for local instance but cannot launch it for the instance on the server (same error).

Used windows authentication with sysadmin role for connection from my machine. On the server used domain\administrator that the account created the instance.

Please help.

SQL 2008 Management studio and Activity monitor


I have an sql 2008 server with Windows 2008 R2 firewall on and the port 1433 and 1434 are open. When I run Activity Monitor from SQL studio remote I can't see all database activity but if I go local on the server I can, why is that ? Another port that should be open or ?


\\Jonas B

Activity Monitor not available in SQL Server 2008?


I've just recently installed SQL Server 2008 Standard.

However, I don't see Activity Monitor listed under the Management folder. I installed all the necessary software, so there can't be any missing software components. My network administrator gave me all the necessary permissions for the server. We're using Windows Authentication for logins. When I used SQL Server 2005 on another server machine, Activity Monitor was available.

Did Microsoft drop Activity Monitor from SQL 2008?

If not, how do I get Activity Monitor back?

Rupertsland, Canada

The exact meaning of "Executions/Min" in SQL Server 2008 Activity Monitor


We are having issue understanding the "Executions/Min" in the Recent Expensive Queries" section of Activity Monitor in SQL Server 2008.

Activity Monitor shows we have 189,411 execution of "insert into t_LiveChat_SessionIncludingNavigatingAndChat33497(visitorId, startTime, Ip, referrerUrl) values(@visitorId, @startTime, @Ip, @referrerUrl)" per minutes. However, if we use SQL Profile to track all ""insert into t_LiveChat_SessionIncludingNavigatingAndChat33497(visitorId, startTime, Ip, referrerUrl) values(@visitorId, @startTime, @Ip, @referrerUrl)" in 2 minutes.

Also, I used the following SQL:


SELECT total_worker_time ,

 execution_count ,

 total_worker_time / execution_count AS [Avg CPU Time] ,

  total_logical_reads, total_logical_writes, total_physical_reads,total_elapsed_time, *,

 CASE WHEN deqs.statement_start_offset = 0

  AND deqs.statement_end_offset = -1

 THEN '-- see objectText column--'

 ELSE '-- query --' + CHAR(13) + CHAR(10)

  + SUBSTRING(execText.text, deqs.statement_start_offset / 2,

  ( ( CASE WHEN deqs.statement_end_offset = -1

   THEN DATALENGTH(execText.text)

   ELSE deqs.st

Sql Server Agent Job Activity Monitor Columns


Hi All,

        We have a requirement to produce the replica of the SQl Server Agent Job Activity Monitor in a list view.We are aware that there are Sql Server Agent stored procedures to get it done.But the problem is that we are not able to obtain columns like Runnable,Category from those stored procedures.

Is a stored procedure readily available for getting it done? Please help us in this regard.





Database column in Activity Monitor is Blank


When we remotely manage a SQL 2008 instance the Database column in Activity Monitor is Blank, but when connected directly it shows up. We do have one user where the database column dose populate but he cannot remember if he did something to fix/enable it or not. These users are logging into this SQL server to get this info instead of managing remotely which I would like them to stop doing but I need to resolve this before they can since this info is critical.


I cannot imagine it is permission related since the column is blank for me as well and I have sysadmin rights over the instance.

Lossless Audio Addict

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

.NET Matters: Deadlock monitor


This month Stephen Toub discusses deadlocks that can occur when synchronizing threads.

Stephen Toub

MSDN Magazine October 2007

Advanced Basics: Monitor Your Apps with System.Diagnostics


It never fails. The application you just deployed ran great on your development machine-but stumbles in production. The problem might show up right away or maybe it creeps up over time. Now what?

Brad McCabe

MSDN Magazine July 2006

Toolbox: Generate Office Documents, Monitor Event Logs, and More


Most data-driven Web sites are used as interfaces to collect, process, and summarize information. Reports that summarize the data can be presented to the user in a variety of formats-the most common way is to display the report directly in a Web page.

Scott Mitchell

MSDN Magazine June 2006

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend