SQL Server Performance Forum – Threads Archive

SP_completed during timeouts

In the Progfiler, All the …:Completed tasks is what I mostly uee for tuning, such as RPC:Completed and so on. Will the statement still be displayed if the batch was never completed due to the timeout? is it more advisable to use <img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tarting??

Profiler show you any RPC completed. Could be in normal way, timeout, Killed, etc. Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

To add Luis’s post include the events <blockquote id="quote">quote:<hr height="1" noshade id="quote"> TSQL: SQL:BatchStarting This event indicates the start of a Transact-SQL batch. The Text column shows the statement being executed. TSQL: SQL<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tmtStarting This event indicates the start of a Transact-SQL statement. The Text column shows the statement being executed. TSQL: RPC<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tarting This event indicates the start of a remote procedure call (RPC). Stored Procedures SP: StmtStarting This event indicates when a statement in a stored procedure is starting execution. <hr height="1" noshade id="quote"></blockquote id="quote"> Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</center>

]]>