Recommendation for Best SQL Server Performance

Configure mdf and ldf file on separate disks for HDB database and for the LTS databases.

By this way write operations to the disk happen in parallel for each database transaction thereby improving performance.

Also each of the following can be configured on a separate disk (preferably SSD instead of HDD):

  1. Operating system and Desigo CC
  2. Desigo CC project
  3. HDB data (mdf) file
  4. HDB transaction log (ldf) file
  5. LTS data (mdf) files
  6. LTS transaction log (ldf) files
  7. HDB and LTS backups, recovery logs and archives

 

Also refer Microsoft recommendations for best SQL Server performance.