Given a RAID composed of SSDs, is the practice of putting MDF and LDF files on physically separate drives still necessary? (Is there any performance effect at all?)
First , welcome to Forums For sure, SSD drives provision much better IO performance without need for buffering as other drives such FC , ATA , SAC ..etc but it has come to talk about DB stress powers we have to perform our best to accommodate IO and CPU resources to sustain any kind of stress workload particularly if we have huge data entity DBs or critical mission DBs .. Moreover , storage capacity issue might be considerable in case Log files grow rapidly for any reason like Bulk DML or DWH that I get scared it might impact adversely on DB files..
