Thanks Gail. So, in my situation if I had used this dmv and figured out which query was using most of tempdb and killed it, I wouldn't have to restart the service? Would adding another tempdb file help for future?