SQL Server Hardware

I am specifying hardware requirements for 2 database servers to a hardware vendor and would like some opinions on how to choose hardware options.
There are 2 scenario's.

One - A production database with up to 200 users hitting the database simultaneously.

Two - A read only production database with up to 100 users hitting the database simultaneously. Should the read only database have a seperate mirrored drive for the transaction logs? Are transaction logs necessary for read only databases?

Can anyone give recommendations? Thanks.
kwoznicaAsked:
Who is Participating?
 
Kevin HillSr. SQL Server DBACommented:
Transaction logs are required for a SQL Server database to function.  For a read-only database, set the recovery model to Simple and the T-log will be minimal.  It can be anywhere, since it won;t be used (other than data refreshes if there are any) and thus won't be a performance hit.


Option A: Seperate physical drives for O/S, Data, T-log and backup.  max out the memory if the databases are more than a few gigs.

Option 2: Again, max out the memory.  Separate the O/S, Data and backups.  On disk local backups are always a good thing.  
0
 
matrix_aashCommented:
It is always best practice to save the transaction log file and the sql data onto different drives. In case of failure of OS atleast the SQL Data is safe if they are on different drive. Secondly performace is better if they are different drive.Transaction logs are necessary or not its upto you to decide as how many times in a day/hour/minute/sec the db is chaning and what is your backup plan.

Hope this helps

Aash.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.