I want to check the performance of m query and i just want to remove cached query results. Is there any suggestion how can i do this.
I just want to check after each modificatin how much improvement in performance
Check the following dbcc commands in BOL.
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
DO NOT ATTEMPT THIS ON A PRODUCTION SERVER!!!!!!!!
AMB
No comments:
Post a Comment