Links

MS SQL

https://williamdurkin.com/2015/09/who-blew-up-my-tempdb

https://datamasterminds.io/tempdb-is-full
(extended events, tempdb, find query)

MAX_DISPATCH_LATENCY 30 seconds.