Solved

Activity Monitor - Task State - SUSPENDED

Posted on 2014-09-11
4
349 Views
Last Modified: 2014-09-13
I'm running a huge query on 70M rows.
Why does the Activity Monitor alway show the task is SUSPENDED?
I have a message "Executing Query'
it's been running for 2 hours.

Any idea what might be going on
0
Comment
Question by:JElster
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
Kash earned 334 total points
ID: 40319029
may be the system is being hammered and it is not responding properly. can you see the query actually being run /executed?
0
 
LVL 1

Author Comment

by:JElster
ID: 40319049
It finally completed after 7 hours.
Why does it constantly show SUSPENDED?
0
 
LVL 19

Assisted Solution

by:Kash
Kash earned 334 total points
ID: 40319142
I have seen it where the system goes very unresponsive and in NOT RESPONDING state where you think that it isn't doing anything but actually it is. Its how Microsoft is I am afraid :)
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 166 total points
ID: 40321310
Why does the Activity Monitor alway show the task is SUSPENDED?
Typically you will see suspended when the session is waiting for some event to complete.  Since your query is on 70M rows, it would be fair to assume that it is waiting on I/O.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help  needed 3 26
SQL Server 2012 r2 - Varible Table 3 24
Problem when I run a simple storeproc - help 4 17
PROPERCASE SCRIPT IN SQL 3 7
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question