performance Analysis | SQL Server Performance Forums

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
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 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 AKTHAR DILMOHAMUD