Choosing Hardware | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Choosing Hardware

What hardware type would i choose based on the following criteria for SQL Server: Let’s say i am going to have 200 users at any given time on my OLTP database server, database size roughly 50GB, web application and plenty of DML against the database? Any recommendations? Thanks,
Check HW topic and many of them answered by Joe…
Moderator All postings are provided “AS IS” with no warranties for accuracy.

This is a common question, and one always hard to answer. The real solution is to perform your own realistic load testing. But this is not always practical. Because of this, I always recommend the biggest hardware you can afford. While not the most cost effective approach, at least hopefully you won’t underbuy, which could be a worse decision. Also, as you read similar questions inthe forum, you might get some clues on what might work best in your situation. ————————————————————–
Brad M. McGehee, SQL Server MVP
Technical Editor/Moderator www.SQL-Server-Performance.Com
Director of DBA Education for www.Red-Gate.Com