Aged Yak Warrior
Posted - 05/03/2013 : 00:42:07
Our production server tempdb has been placed in different drive than the user DB data files. Till now it was fine, from 2 days onwards the size of the DB is growing more than 100 GB which is first time
How do we check which transaction making this much of grow in temp DB.
we have created 4 ndf files for temp db with unlimited maxsize at a growth of 512 MB.
SQL Developer and DBA