I realize this is probably a very open ended question and the answers could vary, but what is the optimal placement for the tempdb, mdf and ldf files in SQL Server 2012 when talking SSD's?
Pre-new-purchase, I had an existing SSD with the SQL Server 2012 core files and tempdb installed on and had both the mdf/ldf on a 7200rpm HDD. I then bought 2 SSD's with the original intention of putting mdf on one and ldf on the other.
But, from reading into it more, separate physical disks for mdf and ldf files don't really apply when it comes to SSD's. Correct?
So, I was thinking of the following:
SSD 1 - SQL Server 2012 Core Files and Windows
SSD 2 - tempdb
SSD 3 - mdf and ldf
If it makes a difference, this will be dedicated to just one database so there won't be any contention between multiple databases.
Is my "thinking" setup good or just simply a waste (i.e. no reason to separate out tempdb) where I now have an extra SSD to make use of elsewhere?