Post reply

SQL Server: Maximum Transactions per Second

  • November 24, 2003 at 8:43 am

    #83567

    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

  • November 24, 2003 at 8:47 am

    #483374

    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]

  • November 24, 2003 at 8:52 am

    #483377

    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

  • November 24, 2003 at 8:55 am

    #483381

    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

  • November 24, 2003 at 8:58 am

    #483383

    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]

  • November 24, 2003 at 8:59 am

    #483384

    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

  • November 24, 2003 at 9:00 am

    #483385

    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]

  • November 24, 2003 at 10:15 pm

    #483480

    Frank --- this not funny ...

    - Rattu

  • November 25, 2003 at 12:07 am

    #483484

    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>

  • November 25, 2003 at 12:56 am

    #483491

    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]

  • November 25, 2003 at 2:23 am

    #483499

    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

  • November 25, 2003 at 2:53 am

    #483503

    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]

  • November 25, 2003 at 2:54 am

    #483504

    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