Sql 2005 Profiler showing "Update ENVSET_1 Set CTLIDX"

neellotus

Dear All,

I am using Sql Profiler 2005 to find slow running queries but under SQL : BatchCompleted EventClass it is showing following statement and it is showing duration 771101 in miliseconds.

I am not understanding this statement please help me & tell what it means so that i can perform some task to fast my SQL server.
Because this statement taking 7 Minutes for completion.

Thanx in advance.

Neel

kriki

Where do you see it takes 7 minutes to finish?
According to your SQL Profiler output it takes 77 seconds.

bbrown

I get 12 minutes and 51 seconds

(771101/1000)/60

kriki

Correct. :oops: Removed a 0 too many.

Can you post the statement?
So we can see what it is.