Post reply

Compare scripts B4 and After a Performance Fix !

  • April 17, 2013 at 6:09 am

    #271276

    "How can I"/"what are all the ways I can" compare a query/SP before and after a Performance Fix, to know whether Am I improved it really. in case of speed, memory, resource and what else..

    Appreciating your helps always,

    Rafi

  • April 18, 2013 at 6:05 am

    #1607669

    You can run SET STATISTICS IO ON before your change, execute the query and review the results in the messages tab. Then run DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS to clear the proc cache make your changes and run the query and review the results in the messages tab again. You can also compare the estimated subtree cost of the execution plan before and after the changes in SSMS.

    NOTE - Do this in a NON PRODUCTION environment, running DBCC FREEPROCCACHE or DBCC DROPCLEANBUFFERS in production will have performance implications.

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply