Well i think its increase both log and mdf/ndf files of tempdb .How to get size of temp table ?
For the first statement, you don't actually know if that's a good idea or not because you don't know how to do the second statement. 😉
You've also not yet told us how big your TempDB is, how many files there are, what their sizes are, what their growth factors are, and nothing about log file in TempDB nor anything about the size of the disk(s) TempDB is on. We need to know all that, please.
Last but not least, we need to know where the code is. Is it contained in a stored procedure? Is it contained in an SQL AGENT job? Where is the code and what is firing it if it's not in a proc or a job?
I need to know all of that so I can tell you where to put the code that will return information about the size of the table in TempDB as it happens.
Also, do you have a scratch or DBA database that we can write to so you don't have to go searching through run logs to find this information? For that matter, do you even have run logs?
Like I said, so far, you haven't given us enough information to help you with this problem. Please claw through the above and provide it all, please. There's nothing I've asked for that would compromise security.