Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2013-05-03 : 00:42:07
|
| Hi,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 timeHow 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.Pls adviseThanks,Gangadhara MSSQL Developer and DBA |
|
|
|
|
|
tempDB size growing like anything