SQL Server Performance Forum – Threads Archive

performance Analysis

Hi 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
DJ

Other option is create real tables instead temporary and use QA to see execution plan.
Of course that is only to see execution plan.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
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
PORT LOUIS
MAURITIUS

]]>