Thanks a lot guys!

Special thanks to Ed, Jacob and Chris, and let me tell you the culprit was the SP with odd codding. Now our client accepted this truth that TempDb is growing just because of such SP. they will soon update it with smoother coding or removed it with new SP.

Thanks a lot..!!

I am very happy to resolve this issue with the help of SQLSERVERCENRAL Masters..!! 🙂