TEMPDB data gets full and when i check there are no long running transactions always
Hence , I captured wait info details on TEMPDB database using extended investigation for further investigation , details below
i found that wait type was network io during the time of tempdb full happened .There is a monitoring sql job which usually always run for all our prod servers and also this intsance . when i killed the job tempdb usage dropped although i doubt that this job is the culrprit but will still show as tempdb open transaction as it runs all the time . How to proceed ?