MatDatasym
asked on
sql server hardware for 15gb database with 1500 users
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.
I would need fault tolerance consideration in with this.
ASKER
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)?
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)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?