Hi what are the precautions to be taken for temp db to avoid of being it get crashed (how it should be designed or maintained to avoid problems), for instance if have a minimum of 2 TB critical user databases on that instance. what to do if the Temp Db is growing faster like anything, is it better to add a secondary file or is it fine if i increase the file size The problem is, there are lot of long running queries, at the same time can i add secondary files to temp Db or is it good to increase the file size or any other better things to be done.
Its a good idea to split TempDB files in alignment with user databases. Once can calculate the TPS rate for various UDBs to decide how many secondary files needs to be added to TempDB. Storing TempDB log files and data files in different physical drives reduce the contentions. Read more from [here] and Let us know if that helps. :