In my production database I have below configuration in TempDb and needless to say I am facing a lot of IO issues on the drive . So, as per recommendation I am planning to change it
Change #1 Adding 2 more .mdf files on different drive.
Change #2 Change initial size of tempdb .mdf size to 1024 and autogrowth to 10%.
Change #3 Change auto-growth of .ldf to 50%
I have three questions:
- Do you have recommendation or correction needs to be made?
- If I create new file and when I will change the intial size or autogrowth, do I need to restart SQL Server or can it impact SQL Server?
- Do I have to create additional .ndf or log file also?
Reference of my other question
As per paul recommendation, do I have to create 20 temdb files