info.sqldbamail (5/1/2016)
Okay can you please suggest me how much sizes of tempdb data files(Max = 8) should be added for a 300 GB production database with 24 core processors
Absolutely no idea.
You need to check your stats and see what size your TempDB database typically grows to under your workload. Use that to determine the starting size for your TempDB files.
As for how many files? Are you seeing allocation contention in TempDB? If not, then you don't necessarily have to add any additional files at all. If you are seeing allocation contention, then try 4, see if there's still allocation contention and increase the file number if there is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability