Solved

sql server hardware for 15gb database with 1500 users

Posted on 2008-10-08
3
223 Views
Last Modified: 2012-05-05
What is the required hardware for a SQL Server database of approximately 15Gb size with 1500 concurrent users?
I would need fault tolerance consideration in with this.
0
Comment
Question by:MatDatasym
  • 2
3 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22669551
does the database use filegroups?

anyhow:
* OS + software installation : mirrored drive
* Database data datafiles: RAID5 (or RAID 10)
* database index datafiles: possibly on a dedicated RAID5 (or RAID 10)
* database transaction log file: possibly on a dedicated mirror per .ldf file (the system databases can all be on any of the other disk, as they are not I/O intensive.
* swap file (for windows), possibly dedicated mirror, otherwise the OS drive will do

the RAID5/10 could be on 1 big SAN storage, with multiple LUNs...

* clustering (2 nodes) if you can get 2 servers

>I would need fault tolerance consideration in with this.
what fault tolerance are you wanting to consider, actually?
0
 

Author Comment

by:MatDatasym
ID: 22669804
Thanks for the reply.
The database is not currently using filegroups, but no there is no reason for this, so (if possible) we could change to use multiple filegroups.

Fault tolerance would be required for:
Server going down
Hard drive going down
Network or network card going down.

What spec would the server or servers need to be in terms ram and cpu(s)?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 22671237

>Fault tolerance would be required for:
>Server going down
>Network or network card going down.
-> clustering

>Hard drive going down
RAID, dual network card (teaming), clustering



RAM & CPU depend more on the database usage.
the more/faster, the better.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Union 2 queries to a cte (temp table perhaps) 9 49
Sql Server group by 10 48
Job - date manual 1 41
SQL works but want to get the XML node data separately 11 26
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question