Hi,
I need a server hardware configuration for Database and application server.
Database server
Database is Sql Server 2012. Minimum database size is 15 GB data(it contain digital & uploaded files) and we are using some complex sql.
Application Server
Our web application in asp.net(C#). It contain almost 1500 web pages. Each page populating data from DB(each table contain minimum 5000 rows) and user can Add/Edit or Delete the records.Minimum 200 user connecting(all users fully connected 9 am to 5 pm).
Current Configuration spec is below
<big><b>Database Server Configuration</b></big>
<b> Minimum Specification Recommended Specification
Memory (RAM) 32 GB 64 GB
Processor 2 x 3.0 GHz or higher 4 cores 4 x 3.0 GHz or higher
Intel 64 Xeon processor cores Intel 64 Xeon processor
Hard disk 1. RAID 1 - for OS/Programs 1. RAID 1 - for OS/Programs
2. RAID 5 - different raid arrays for 2. RAID 10 – different raid arrays
data, logs and tempdb for data, logs and tempdb
Software Windows Server 2012 R2, SQL Windows Server 2012 R2,SQL Server
Server 2012 Standard Edition 2012 Enterprise Edition</b>
<big><b>Web Server Configuration</b></big>
<b> Minimum Specification Recommended Specification
Memory (RAM) 32 GB 64 GB
Processor 2 x 3.0 GHz or higher 4 cores 4 x 3.0 GHz or higher
Intel 64 Xeon processor cores Intel 64 Xeon processor
Hard disk RAID 5 RAID 5
Software Windows Server 2012 R2, Windows Server 2012 R2,
IIS 8, .NET Framework 4.5 IIS 8, .NET Framework 4.5</b>
If any mistake/ miss something please let me know