disk utilization job stuck #509
abco-alekseev
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I have sqlwatch 4.11 installed, and in my environment, the SQLWATCH-[WATCHSQL]-LOGGER-DISK-UTILISATION scheduled job gets stuck on step 1 (exec dbo.usp_sqlwatch_logger_disk_utilisation)
If I run exec dbo.usp_sqlwatch_logger_disk_utilisation manually in ssms, it runs fine. When the job runs, it shows the process as suspended, with wait type LCK_M_S
I believe the job ran once successfully last night, then got stuck this morning at 5am. I've killed the process, and it just sticks again when run as a job.
Steps 2,3 seem to complete fine as a job.
Beta Was this translation helpful? Give feedback.
All reactions