Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scalability of SQL Query Expand / Collapse
Author
Message
Posted Tuesday, November 6, 2012 6:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 10:41 PM
Points: 45, Visits: 289
Hi, Can you help me understand how I can check the scalability of an SQL query.

- Nidhi
Post #1381547
Posted Tuesday, November 6, 2012 7:01 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 8:15 AM
Points: 653, Visits: 1,428
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/
Post #1381553
Posted Tuesday, November 6, 2012 9:50 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 10:41 PM
Points: 45, Visits: 289
Thank you - this helps
Post #1381786
Posted Tuesday, November 6, 2012 10:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 8:34 AM
Points: 23, Visits: 128
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
Post #1381791
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse