I have a monitoring tool that is giving me alerts that Session id XXX of database ZZZ is using 376 MB of space in tempdb. I actually have 5 messages of various size MB's with 5 different session ids, totaling about 1500 MBs. Any idea why this is happening? I also notice that that ZZZ database does not have a maintenance plan. Would a maintenance plan help my situation?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.