Surendra Sharma

Surendra Sharma

Search This Blog

Tuesday, October 18, 2016

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

SQL Server Configuration
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.

No comments:

Post a Comment