How to improve TempDB performance?
1) TempDB file size and physical placement on harddrive can affect the performance of a system
2) Set the tempdb recovery model to simple
3) Do the capacity planning of the TempDB database and pre allocate the appropriate size to MDF files, which will improve performance for allocating size
4) Put TempDB on fast I/O System
5) Create as many tempdb data files by considering the number of cpu
6) make all the tempdb data file size same
No comments:
Post a Comment