SQL Server Hardware

Posted on 2007-10-18
Last Modified: 2010-04-19
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.
Question by:kwoznica
    LVL 8

    Expert Comment

    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

    LVL 21

    Accepted Solution

    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.  

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now