Sql-server – SQL Server installation location

sql serversql server 2014sql-server-2012

What is the best practice recommendations for installing SQL Server 2012 or 2014 with regards the installation files location. Can the installation files location resides on the system drive or should it have a dedicated drive?

Best Answer

For production instances it is recommended to create separate partitions for the following elements of SQL Server:

  • data files
  • transaction log files
  • tempdb files

Some people also suggest to install SQL Server on a dedicated partition instead of the C: drive but I think it is an overkill and does not bring any benefit. The installation itself cannot grow out of control. System databases other than tempdb can (theoretically) do that. I would also recommend putting them and their log files on a different partition.

You should definetely not put data/tempdb/log files on the same partition as the OS, because if you run out of space for say tempdb, the OS might not be able to perform correctly when out of space.

Also there is another big topic of data separation on different physical drives for security/performance reasons but I will not go into that.