Avatar of Jim Metcalf
Jim Metcalf
Flag for United States of America

asked on 

SQL has some stuck tasks

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
Microsoft SQL Server

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon