SQL Server: Maximum Transactions per Second

  • What is the maximum transactions that are supported by SQL Server, provided with good hardware/Software support?

    Currently single CPU of 1.8GHz is installed with a 512MB of RAM on Windows 200 Advance Server. I have to identify, whether my Real-Time application support multiple insertion queries that are executing at a frequency 1 Transaction/Second. And also multiple select queries are running parallel to these insertions. Please help me out if this configuration will be OKEY for the kind of Application.

    Thanking in Advance.

    - Rattu

  • http://www.tpc.org

    http://www.sql-server-performance.com/ultimate_sql_server.asp

    Don't know much about hardware, but you should spent this box more RAM.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • The best way is to test with your data and environment. There are too many variables to answer a question like this in an online forum.

    quote:


    Don't know much about hardware, but you should spent this box more RAM.


    What if the database size is only 100MB?

    --Jonathan

    Edited by - Jonathan on 11/24/2003 08:57:11 AM



    --Jonathan

  • Thanks Frank, but I need information about what actually is the capacity of SQL Server to manage insert and select queries simultaneously...

    looking for reply

    - Rattu

  • Like Jonathan said, stress your server with a test scenario and choose the scenario that you would consider worst case.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • I am currently planning for deploying SQL Server at client. There is no historical data available. So, everything is at conceptual level, as you know planning is the formost thing before deploying 😉

    - Rattu

  • quote:


    quote:


    Don't know much about hardware, but you should spent this box more RAM.


    What if the database size is only 100MB?

    --Jonathan

    Edited by - Jonathan on 11/24/2003 08:57:11 AM


    Interesting, lots of resources...

    So we should put on IIS and make it a PDC

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Frank --- this not funny ...

    - Rattu

  • I think Frank was very funny.

    You'd be better off asking how long is a piece of string - but REALLY it should have more ram no matter what other hardware is in there.

    Please do not poke the DBA


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • quote:


    Frank --- this not funny ...


    Sorry, I didn't want to annoy you !!!

    Basically I was joking on Jonathan's reply.

    Now seriously, put up a test scenario. There should be tools that will you on this around.

    And do plan and develop for peak usage.

    You write that you have a frequency of 1 transaction per second. ...on average?

    It should be a huge difference if it is really one transaction per second equally spread over the whole day or 86,400 at once (which is also 1 transaction per second on average).

    Also it depends on the kind of transactions your application does.

    If you're still uncertain, you should consider asking some consultant in your area. Like Jonathan said there are too many variables involved so that any concrete advice would be like a shot in the dark.

    And, once again, sorry if you felt offended!

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • no Frank I wasn't annoyed ... well I am confused with another problem now 🙁 for this one, I have tested a little and now I think that the load will not exceed hardware availability ... and I am confident that I can now safely design it ... thanks for your help ... thanks everyone.

    The other problem now i am facing is in regard of backups ... please help me out ... i cannot find a way to restore some previously backup data along the new changed database. Can you please suggest me if there is any option to accomplish this?

    Edited by - rattu on 11/25/2003 02:33:40 AM

    - Rattu

  • Start a new thread so more people will be aware of the new subject line.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Oh, well, you've already done this ...

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 13 posts - 1 through 12 (of 12 total)

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