Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Compare scripts B4 and After a Performance Fix ! Expand / Collapse
Author
Message
Posted Wednesday, April 17, 2013 6:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, December 12, 2014 12:10 PM
Points: 88, Visits: 325

"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
Post #1443209
Posted Thursday, April 18, 2013 6:05 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 5:00 AM
Points: 1,797, Visits: 499
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
------------------------

Post #1443774
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse