Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

sql server hardware for 15gb database with 1500 users

Posted on 2008-10-08
3
217 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query to return total 6 21
Query Syntax 17 43
Downgrading MS SQL 2008 R2 Enterprise to MS SQL 2005 Standard? 12 65
average of calculation (TSQL) 4 26
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
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…

840 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