Solved

sql server hardware for 15gb database with 1500 users

Posted on 2008-10-08
3
231 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
[X]
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
  • 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

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

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…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

717 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