Best practices for log and mdf files is to split across drives (e.g.
G:\SQL Data &
What are the best practices for memory optimization files? Should they reside on their own drive? Can they reside on a Azure Temp drive (better IO performance but files will be lost on redeploy, tempdb can be hosted here)?
I am still unclear on the purpose of the Memory Optimized file set and what is actually stored there and the rate of IO.