Post reply

What is Update ENVSET_1 Set CTLIDX = '33C49884-A1BF-4899-B2E3-29D45370D3EB' in TextData of SqlProfiler Event

  • August 31, 2012 at 10:37 pm

    #266146

    Dear All,

    I have created trace template to find slow running queries of SQL Server-2005.

    So i created trace with following events:-

    RPC:Completed, SP:StmtCompleted, SQL:BatchStarting, SQL:BatchCompleted, Showplan XML

    I found statement named "Update ENVSET_1 Set CTLIDX = '33C49884-A1BF-4899-B2E3-29D45370D3EB' "

    in TextData Column under SQL:BatchCompleted Event Class.

    I am not understanding this statement and it is always taking execution time >2 Minutes.

    Please tell me what is the meaning of this statement i will be very thankfull 2 u.

    Thanx in advance.

    Regards

    Neel

  • September 2, 2012 at 9:50 pm

    #1532804

    An UPDATE with no WHERE clause can take a relatively long time depending on how many rows are in the table. I do not recognize the table as one that is built into SQL Server. Look for it in one of the user databases. Swap Profiler out for Server-Side Trace. Capture the database name, host name and login name in your trace as that will help you track down why these long running queries are being executed.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply