SQL Server Performance

System Requirements

Discussion in 'Performance Tuning for Hardware Configurations' started by mtinderholt, Jul 21, 2004.

  1. mtinderholt New Member

    I am planning to rollout web hosting services for some of my custom software clients. I primarily work with (ASP).NET & SQL Server Solutions. Any recommendations on minimum system requirements for an ASP.NET + SQL Server environment?
  2. Twan New Member

    Hi ya,

    this is really a 'how long is a piece of string' kind of question...

    depends on for example:
    - number of concurrent users
    - size of the database(s)
    - DR requirements
    - availability requirements
    - performance requirements
    - size of the tables
    - complexity of the SQL statements
    - budget
    etc, etc.

    I'd suggest developing on a Desktop or an existing server/set of servers and then try to extrapolate some of the above (or get answers from superiors on some others...)

    Cheers
    Twan

  3. bradmcgehee New Member

    Like Twan says, this is hard to recommend without some idea of the load.

    But I can say that RAM is your most critical components, and since it is relatively cheap, get as much as you can afford.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com

Share This Page