tempdb growth SQL 2008 R2
Posted on 2014-07-31
I was performing a test upgrade of a software package and could not figure out why it kept crashing. Later, I discovered that it was an out of disk space issue. However, the DB size is only 5GB and I have 50GB free. What I discovered was it was not the database for the software that was growing it was the tempdb. I tried running SQL Profiler to see what was going on but that shows no activity. The activity Monitor in SQL show some activity but not enough to account for this growth. What tool can I use to find out why the database just keeps growing until all disk space is consumed?