InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 23:49:18 GMT20http://www.sqlservercentral.com/Forums/Topic1381547-1550-1.aspxScalability shows the dependency of performance on factors like the data volume i.e. data stored in a databaseThe 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 growsin short we can say that if we want to improve scalability of a query we have to improve our SQL SERVER performance & capacity managementTue, 06 Nov 2012 22:31:56 GMTpeterdru401http://www.sqlservercentral.com/Forums/Topic1381547-1550-1.aspxThank you - this helpsTue, 06 Nov 2012 21:50:57 GMTnpranjhttp://www.sqlservercentral.com/Forums/Topic1381547-1550-1.aspx[quote][b]nidhis (11/6/2012)[/b][hr]Hi, Can you help me understand how I can check the scalability of an SQL query.- Nidhi[/quote]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/Tue, 06 Nov 2012 07:01:20 GMTGeorge M Parkerhttp://www.sqlservercentral.com/Forums/Topic1381547-1550-1.aspxHi, Can you help me understand how I can check the scalability of an SQL query.- NidhiTue, 06 Nov 2012 06:50:44 GMTnpranj