Timeline for how to kill a rogue spid that is already killed?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 21, 2023 at 13:36 | comment | added | Sean Gallardy | Nice, I didn't know this was a open source thing, thansk @AMtwo! | |
| Dec 21, 2023 at 5:26 | comment | added | AMtwo |
@Sean that sqlwatch view joins to dm_hadr_database_replica_states which would explain the wait github.com/marcingminski/sqlwatch/blob/main/SqlWatch.Monitor/…
|
|
| Dec 20, 2023 at 16:28 | comment | added | J.D. | @SeanGallardy Agreed. I noticed that wait type too and let Paul Randall explain what it meant to me since it's above my head lol. I can't imagine how inserting into a temp table would be related to anything waiting on HADR (presumably the Availability Group in use). But idk, my knowledge of AGs is limited too 🤷♂️. | |
| Dec 20, 2023 at 16:03 | comment | added | Sean Gallardy |
It'd be interesting to get a dump and see what the thread is trying to do. The wait type was HADR_CLUSAPI_CALL but none of those views seem as though they'd reach out to the cluster. If it's in that wait type, then it's preemptive, which is why it most likely isn't responding because it's not under the purview of a scheduler at the moment.
|
|
| Dec 20, 2023 at 14:21 | vote | accept | Marcello Miorelli | ||
| Dec 20, 2023 at 13:05 | history | edited | J.D. | CC BY-SA 4.0 |
added 190 characters in body
|
| Dec 20, 2023 at 12:58 | history | edited | J.D. | CC BY-SA 4.0 |
added 253 characters in body
|
| Dec 20, 2023 at 12:48 | history | answered | J.D. | CC BY-SA 4.0 |