SQL TempDB on RAMDisk or PCI-E?

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 ?


Leave a Reply