After we deploy SQL server 2008 SP2, we start to receive more and more incident about the out of space of the TEMPDB drive.
May I know if anyone tried this kind of experience? any fix needs ?
As we can't restart the SQL server in order to free disk space up, any other suggestion? session of tempdB hard to kill as user is using it.