Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 532
  • 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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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