I'm setting up my production SQL server. I have two 800GB SSD disks available to me (for Windows and SQL Server).
Where should I put databases' data and log files?
How many tempdb files should I create and what size should they be?
Some recommendations are to create 1 tempdb file for 1 processor core. That would mean 16 files in my case (2 processors with 8 cores each). That seems too many to me... Does this recommendation make sense on SSD?
Should I put log and data files into different SSD?
I use SQL Server 2008 R2 and server has 32GB RAM.