SQL Server Performance

SP_completed during timeouts

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by BikeBoy, Apr 9, 2007.

  1. BikeBoy New Member

    In the Progfiler, All the ...:Completed tasks is what I mostly uee for tuning, such as RPC:Completed and so on.<br /><br />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??
  2. Luis Martin Moderator

    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.



  3. satya Moderator

    To add Luis's post include the events <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" 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. <br />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. <br />TSQL: RPC<img src='/community/emoticons/emotion-7.gif' alt=':S' />tarting This event indicates the start of a remote procedure call (RPC). <br />Stored Procedures SP: StmtStarting This event indicates when a statement in a stored procedure is starting execution. <br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>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.</i></font id="size1"></font id="teal"></center>

Share This Page