• I'd recommend you place your TEMPDB Log file on a different drive...

    Seems like nice hardware for the server regarding CPU's but what about RAM and the disk subsystem? I am going to assume that there's nothing else on these 2 SSD's except for tempdb, and would suggest purchasing two additional drives so you can put them into a RAID 10 configuration (ideal for tempdb performance and reliability).

    There's really no need to have 8 tempdb data files until you're experiencing tempdb contention and then I would suggest only adding 1 new file at a time to see if things improve.

    If you split out all your space across smaller data files you may run into issues with command DBCC operations like CHECKDB not having enough space available in your tempdb data files to perform CHECKTABLE on your larger tables (unlikely, but still possible).

    If you're stuck with 2 disks, I would recommend:

    Disk 1

    T1: 140 GB (set size, NO AUTOGROWTH)

    T2: 140 GB (set size, NO AUTOGROWTH)

    Disk 2

    Tlog: 260 GB, leaving a few GB to grow

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience