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