January 8, 2013 at 8:45 am
Is there a way to have a query run for only lets say 1 minute and have it return results? I am trying to compare 2 queries and i have been manually stopping them in SSMS but i want to make sure that they run for the exact amount of time each so i can accurately show the difference in performance.
January 8, 2013 at 9:50 am
zulmanclock (1/8/2013)
Is there a way to have a query run for only lets say 1 minute and have it return results? I am trying to compare 2 queries and i have been manually stopping them in SSMS but i want to make sure that they run for the exact amount of time each so i can accurately show the difference in performance.
No you can't do that. That is not the best way to demonstrate performance differences. Performance shouldn't be measured by 'How much can we get back in 10 seconds". Data is in sets. The question really is "how long does it take to get my data"? The only way to calculate that is to get the entire set and compare run times.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply