Click here to Skip to main content
15,880,427 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
Posted
Updated 24-Oct-13 19:53pm
v11
Comments
ZurdoDev 24-Oct-13 10:06am    
Get the best you can afford. Otherwise, what's the question?

SQL Server Sizing Resources[^]
Server Sizing Guide[^]

Those should at least point you where to start.
 
Share this answer
 
Comments
thatraja 24-Oct-13 11:06am    
5! I did update his question for answers. Wanted to see some interesting answers.
phil.o 24-Oct-13 11:18am    
Thanks :)
I would suggest not putting both on one.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900