SQL Server Performance

SQL Server performance using SSDs

Discussion in 'ALL SQL SERVER QUESTIONS' started by BCinNC, Oct 8, 2012.

  1. BCinNC New Member

    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?)
  2. Shehap MVP, MCTS, MCITP SQL Server

    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..

Share This Page