Ship RAM Disk with Windows Server
I would like Windows Server 2016 to ship with an option to install a RAM Drive that can be configured to load as a device driver upon operating system boot.
This could be used for a variety of reasons, but my primary case is for optimizing SQL Server workloads. (I might that I use a RAM disk with my Windows 8.1 computer for the TEMP and IE TEMP directories, which is a great way of clearing out cookies, malware, etc as I just reboot the computer)
Use / Business case:
In earlier versions of SQL Server you were able to configure [tempdb] to reside in RAM only. Microsoft has since removed that feature. SQL Server product team has indicated that they will not be "resurrecting" that feature.
You can now easy buy a commodity server with 32 cores and 768GB of RAM. However in a lot of such servers the bottleneck is the [tempdb] system database. The [tempdb] system database con be optimized. But once it has been optimized there is nothing that can be further done. Furthermore the [tempdb] system database never grows beyond, lets say 32GB.
So given this scenario I would like to move maybe all of the [tempdb] files, or let's say just the LDF, or MDF/NDF files knowing my system.
[tempdb] would work at DDR3/DDR4 speeds thereby maximizing it's performance.
With more and more work being done by SQL Server's [tempdb] this would greatly improve performance.
Furthermore I could use this RAM drive in other ways. Staging are for files. A non-durable database that I create upon SQL Server starting, etc.
It would also be a optimization technique that I could use in AWS / Azure with IaaS. I've had scenarios we had a 4GB database on a 24GB VM in AWS for a predominantly read-only workload where [tempdb] activity brought the website down. If I was able to move [tempdb] into a RAM drive it would have worked superbly.
Microsoft already has the potential source code for this built: https://support.microsoft.com/en-us/kb/257405
I just needs to be RTM quality :)