Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execution Plan Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 9:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 16, 2015 4:19 AM
Points: 370, Visits: 698
when i'm looking at stored procedures i add the following to the top of the code
dbcc freeproccache
set statistics io on
set statistics time on

Is there also a way to turn on the real execution plan this way, by a command, instead of by mouse?
thanks very much
drew
Post #1453174
Posted Wednesday, May 15, 2013 9:21 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 9:16 AM
Points: 863, Visits: 1,291
CTRL+M
Post #1453176
Posted Wednesday, May 15, 2013 9:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 16, 2015 4:19 AM
Points: 370, Visits: 698
obviously, didnt know that
thanks a ton!
Post #1453197
Posted Wednesday, May 15, 2013 10:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:33 PM
Points: 10,709, Visits: 14,431
SET STATISTICS XML ON;



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1453216
Posted Thursday, May 16, 2013 7:13 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 16, 2015 4:19 AM
Points: 370, Visits: 698
Hot Dawg!
even better
thanks very much
drew
Post #1453512
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse