SQL Server Performance

case studies about hardware

Discussion in 'Performance Tuning for Hardware Configurations' started by chopeen, Aug 12, 2004.

  1. chopeen Member

    I am looking for case studies describing deploying MS SQL Server 2000 in different environments, on different machines.

    I have been assigned a task of finding a new server for one of our customers and I am looking for information about what kind of hardware is needed for SQL Server to run smoothly (of course, I know it depends on the way it is used).

    --

    Marek 'chopeen' Grzenkowicz, MCP
    Poland
  2. FrankKalis Moderator

    You might search the website of the big vendors like IBM, Dell, HP, EMC... I know, at least, IBM, HP and EMC have such case studies there, vut I only downloaded them and do ot have the URL's right now. Another starting point would be to look at the homepage of SQL Server at Microsoft. They have also a case study section.


    --Frank
    http://www.insidesql.de
  3. chopeen Member

    I've checked IBM, Dell and MS.

    The problem is that I need really detailed information -- number of users, application characteristics, hardware used, etc.

    --

    Marek 'chopeen' Grzenkowicz, MCP
    Poland
  4. Luis Martin Moderator

    Try to find:
    1) Application is more input than output.
    2) " is I/O balanced?
    3) More CPU than I/O?
    4) How database will grow in time?
    5) Are you planning backup transactions log frequently?
    6) The application is well tuning or you have to improve performance after?




    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  5. bradmcgehee New Member

    If you can offer some more specifics about the use, then perhaps those DBAs who have similar systems can offer to describe what hardare they have to run a similar system.

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

    I have very detailed information about the application.

    However, I need some examples like 'when there are X1 users, X2 reads per sec, X3 writes per sec and the database is X4 GB, then you probably need a machine with Y1 CPUs, Y2 GB of RAM and X3 disks'.

    --

    Marek 'chopeen' Grzenkowicz, MCP
    Poland
  7. chopeen Member

    There are 7 databases:
    8GB -- 100+ users
    20GB -- 30 users
    5x 3GB -- 5 users each

    Each database is used by the same application -- it is an OLTP application with some reporting capabilities.

    --

    Marek 'chopeen' Grzenkowicz, MCP
    Poland
  8. bradmcgehee New Member

    What you describe is smaller than all of the SQL Servers I manage.

    Our system, closest to yours, is a 4CPU XEON, with 8GB RAM, and RAID 5 SAN for storage. On our particular system, we have no hardware bottlenecks. If you purchase a system as big, or bigger than ours, then you will probably see no performance issues. In fact, I imagine that a smaller system will also so as well, such as a 4 CPU Xeon, 4GB RAM, and RAID 5 on the local server.

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

    quote:Originally posted by bradmcgehee

    What you describe is smaller than all of the SQL Servers I manage.

    Our system, closest to yours, is a 4CPU XEON, with 8GB RAM, and RAID 5 SAN for storage. On our particular system, we have no hardware bottlenecks. If you purchase a system as big, or bigger than ours, then you will probably see no performance issues. In fact, I imagine that a smaller system will also so as well, such as a 4 CPU Xeon, 4GB RAM, and RAID 5 on the local server.

    Thanks for your answer -- that it exactly the kind of information I need. Of course, I realize that nobody is able to give me precise answer based only on my short desription. But, since it is the first system that I am designing, I need some starting point.

    Could you tell me something more about the disk subsystem?
    How do you have OS, paging file, transaction logs, data logs and tempdb placed?

    --

    Marek 'chopeen' Grzenkowicz, MCP
    Poland
  10. satya Moderator

Share This Page