I asked this question over at dba.stackexchange
Since we have 800 GB of memory and databases are only ~250 GB, we’re planning to put SQL server’s tempdb files on RAMDisk by allocating 100GB to its data and log files, instead of current SSDs (SAN Tier 1), since our vendor application is very tempdb intensive.
Is it better than PCI-E cards ? We care about speed only, not about persistence, since tempdb gets dropped and recreated everytime SQL is rebooted.
And we prefer WQHL certified vendors. Are there any to specifically choose or avoid ?