Solved

Activity Monitor - Task State - SUSPENDED

Posted on 2014-09-11
4
329 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
Comment Utility
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
Comment Utility
It finally completed after 7 hours.
Why does it constantly show SUSPENDED?
0
 
LVL 19

Assisted Solution

by:Kash
Kash earned 334 total points
Comment Utility
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
Comment Utility
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
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 …
This video discusses moving either the default database or any database to a new volume.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now