SQL Server Performance Forum – Threads Archive
performance AnalysisHi members, How do I execute the showplan to get the overall cost of the procedure, if the stored procedures uses temporary tables.I tried using CTRL+L option available in the SQL Query Analyzer 2000, I could get the cost of the procedure using CTRL+K but the result shown was in parts which doesn’t enable me to estimate the overall cost. Thanking you in anticipation. -Ajay
while executing your SP, you can use Server Trace (ctrl + shift + t ) to find out what procedure is doing. Thanks N’ Regards
Other option is create real tables instead temporary and use QA to see execution plan.
Of course that is only to see execution plan.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
maybe have a look at third party tools
http://www.idera.com AKTHAR DILMOHAMUD
65 BENARES ST