Sitecore database lesson 9 - Sitecore SQL server configuration on hosting environment

SQL Server Configuration

Below is a hardware and OS reference table for SQL server configuration on Sitecore hosting environment like Production, staging etc.

Specification	Content Delivery	Content Authoring Server	Session State Server
OS	Windows Server 2008 R2/2012/2012R2 – 64bit	Windows Server 2008 R2/2012/2012R2 – 64bit	Windows Server 2008 R2/2012/2012R2 – 64bit
CPU	Dual Quad Core Processors	Dual Quad Core Processors	Dual Quad Core Processors
Memory	16 GB RAM	16 GB RAM	16 GB RAM
Disk Space	250 GB disk for data files 250 GB disk for log files	250 GB disk for data files 250 GB disk for log files	100 GB disk for data files 100 GB disk for log files
SQL Version	SQL Server 2008 R2/2012/2014- 64bit	SQL Server 2008 R2/2012/2014- 64bit	SQL Server 2008 R2/2012/2014- 64bit
Dedicated Database Server/cluster	Yes	Yes	Yes

Tip: - You should keep separate database server for maintaining sessions on production environment to improve the performance of website.

I hope you like this Sitecore database lesson. Stay tune for more Sitecore database related articles. 

Please leave your comments or share this article if it’s useful for you.