Performance Tuning – Steps to make sure that you are comparing apples to apples

Posted on : 09-08-2015 | By : Devi Prasad | In : Performance Tuning

Share:

0


While working on optimizing performance of SQL Queries, its very important that the right numbers are compared.
Performance numbers might vary with each execution mostly due to SQL Server cache and buffer.

Below are the steps that can be taken to make sure that you are seeing right numbers.

– Clear the cache by running the above Script provided in this Link
– Run the query that you are trying to performance tune and note the Statistics. (a)
– Run the above script again to clear the cache.
– Now execute the tuned query and note down the Statistics. (b)

Query Statistics (a) and (b) would now be comparable as both of them are executed over the clean cache.

(Visited 284 times, 1 visits today)



References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Write a comment