Different Drives

Question

Experts , Please advise if it helps to place mdf files of multiple databases segregated across multiple all flash drives or placing them all on one drive will not make much of a difference. Drives are all flash RDM

Answer 1

Hello,

Usually putting the data files of multiple databases (or a database with multiple data files) on different disk drive can achieve the purpose of distributing the I/O load, this helps performance. Also check this document for some recommendations when working with SQL Server database files and filegroups.

I am not familiar with RDM, please refer to following posts if help.

Better performance is more likely to be achieved by spreading database files across multiple VMDKs/RDMs. At a minimum, split database and log into different VMDKs/RDMs.
https://support.purestorage.com/Solutions/Microsoft_Platform_Guide/Microsoft_SQL_Server/001_Microsoft_SQL_Server_Quick_Reference

https://communities.vmware.com/t5/ESXi-Discussions/Peformance-Gain-for-different-drive-for-SQL-Server-data-and-Log/td-p/915974