• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 808
  • Last Modified:

Activity Monitor - Task State - SUSPENDED

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
JElster
Asked:
JElster
  • 2
3 Solutions
 
Kash2nd Line EngineerCommented:
may be the system is being hammered and it is not responding properly. can you see the query actually being run /executed?
0
 
JElsterAuthor Commented:
It finally completed after 7 hours.
Why does it constantly show SUSPENDED?
0
 
Kash2nd Line EngineerCommented:
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
 
Anthony PerkinsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now