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

SQL Server 2008 backup running long - suspended

SQL Server 2008 r2 - 6 GB memory

I attempted a backup on a 500GB database but it was taking way too long.   I checked the resources on the box and saw the CPU at 100%.   I checked the SQL Server activity log and saw a hung query (user was not even logged on) that had multiple threads so I killed it and now the CPU utilization is back to normal.

Trouble is, now all of the threads in the activity monitor for the backup show 'suspended' and the backup appears to be not doing anything.
1 Solution
Aneesh RetnakaranDatabase AdministratorCommented:
Check the sp_Who2k5 (link below)
 and run this , there is a PercentileComplere  column, that could be useful
sp_who2k5 1,1

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

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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