Click here to Skip to main content
15,889,462 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?

I would suggest not putting both on one.
 
Share this answer
 
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 :)

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