I have seen the issues when very large/complex processing is going on the database servers. If the code generates lots of temporary data then tempdb will grow.

If the server is a highly utilized server then do the following…

1. Move the tempdb to different drive so that you can spread the IO.

2. Split the data files based on number of CPU’s on the servers.

3. Check stored procedures that are creating the objects. Make sure that objects are getting disposed once process is done.

4.You can run a profiler trace to look for long running queries.

5.Restart the server to clean up the temporary objects(Every time server restarts a new tempdb will get created).

Thank you,

Regards

Hema.,