Best Hardware for SQL Server

  • get a 64bit dual core server with at least 16gb of ram. Memory will offset most disk subsystem performance problems. make sure at least that o/s+ binaries, tran logs, data and backups exist on seperate drive arrays ( four arrays minimum ) Try to avoid raid 5 , a raid 1 pair will perform as well as a four disk raid 5 for writes so if your system does more writes than reads don't use raid 5. You must know how your current system works ? judge the cpu from there but probably a dual dual core would be good. The good news is 64bit std edition has no memory limits so will reduce licensing costs.

    I never look at hardware prices, I spec servers for a need, others make the decision vs costs etc.,

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply