Posted by comp_databases_ms-sqlserver on 10/26/06 18:29

SET STATICS PROFILE ON is a good solution. Thanks for that. How do you
troubleshoot performance problems of a proc with 2000+ lines of code
that is using 10+ temp tables?
I am not able to configure SQLDebugger from a client. I have to be on
the server to use it. This applies to SQL2000.

• Next in forum: database analysis
• Prev in forum: SQL 2005: Unable to edit linked table records
• Thread view: Re: How to find query plan for a stored procedure using temporary tables

[Reply to this message]