Sample Header Ad - 728x90

Some of our backup jobs have begun to hang, and quietly cause some issues

0 votes
0 answers
34 views
We’ve been using SQL Server Maintenance Solutions for decades, but recently I’ve started encountering issues with missing log backups. There are no error messages, and the jobs are still scheduled, but when I check the job history, I see that it hasn’t run since [X time]. Upon further investigation, I found that the session executing the job is waiting on the OS (specifically on PREEMPTIVE_OS_GETPROCADDRESS). It also seems to be tied to the xp_create_subdir and xp_fileexist procs. The issue can be temporarily resolved by killing the process, though it won't clear until a restart. Once I do that, the jobs start running again. This issue happens anywhere from a few times a week to not at all for several months. I’d appreciate any help in identifying the root cause. enter image description here
Asked by Pat Trongo (1 rep)
Jan 24, 2025, 05:17 PM