• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 585
  • 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.
0
itsonlyme4
Asked:
itsonlyme4
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

http://blogs.msdn.com/chadboyd/archive/2007/08/15/sp-who-for-sql-2005-sp-who2k5.aspx
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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