Wison (8/22/2014)
Hi all,I found the tempdb log file size of one instance increased to 200 GB.
how can i get the root cause of the issue?
any answer is appreciated.
thanks.
You can reduce the tempdb size by using T-SQL, DBCC shrinkDataBase and DBCC shrinkFile. For more information about these visit : http://support.microsoft.com/kb/307487