troubleshooting Question

SQL has some stuck tasks

Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America asked on
Microsoft SQL Server
2 Comments1 Solution39 ViewsLast Modified:
Hi everyone-
My sql instance has some stuck tasks displaying in activity monitor.  It concerns me.
I have 3 maintenance tasks for backups that run.
1 for full that runs on the weekends
1 for dif that runs every night
1 for transaction logs that run every 3 hours

the differential and fulls have quit running recently and I think the problem is being keyed in on by the activity monitor.
I have already issued a kill statement on task spid 51.
Can someone take a look at this screenshot and tell me if I am in a "situation" here.

I plan on rebooting this server tonight to hopefully rid it of the stuck tasks but I am concerned.

Thanks a ton
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros