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.