Post reply

Scalability of SQL Query

  • November 6, 2012 at 6:50 am

    #284528

    Hi, Can you help me understand how I can check the scalability of an SQL query.

    - Nidhi

  • November 6, 2012 at 7:01 am

    #1556445

    nidhis (11/6/2012)

    Hi, Can you help me understand how I can check the scalability of an SQL query.

    - Nidhi

    What exactly do you mean by "check the scalability of an SQL query"? Are you interested in how many concurrent executions you can run, will it cause blocking, etc?

    Here's a link to a query stress testing tool written by Adam Mechanic that might help:

    http://www.datamanipulation.net/SQLQueryStress/

    And perhaps read the following SQLServerCentral.com post on how to post a performance problem and add some additional detail to this thread.

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • November 6, 2012 at 9:50 pm

    #1556632

    Thank you - this helps

  • November 6, 2012 at 10:31 pm

    #1556637

    Scalability shows the dependency of performance on factors like the data volume i.e. data stored in a database

    The response time of an SQL query depends on many factors. The data volume is one of them. If a query is fast enough under certain testing conditions, it does not mean it will be fast enough in production. That is especially the case in development environments that have only a fraction of the data of the production system.

    It is, however, no surprise that the queries get slower when the data volume grows

    in short we can say that if we want to improve scalability of a query we have to improve our SQL SERVER performance & capacity management

Viewing 4 posts - 1 through 3 (of 3 total)

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