Post reply

Viewing User Queries !

  • July 17, 2006 at 6:31 am

    #60932

    Hi All,

     

    I am trying to view user queries without using profiler, as most of the time i want a quick fast answer.

    When i use dbcc inputbuffer, it doesnt give me the whole query the user is running, DBCC input buffer has a max length, if the query is a long one, it would cut some out.

    I tried inserting dbcc input buffer results into a table, still thesame thing.

    Does anyone know how else i can accomplish this task ?

     

     

    Kindest Regards,

    John Burchel (Trainee Developer)

  • July 17, 2006 at 9:03 am

    #649581

    Read up BOL for fn_get_sql()  (this was introduced in SP3 for SQL 2000).

  • July 17, 2006 at 3:10 pm

    #649686

    Profiler is the quick answer.

    Did you mean server side traces?

    Regards,Yelena Varsha

  • July 18, 2006 at 7:34 am

    #649777

    fn_get_sql is unreliable in returning results. Profiler is the only way. You could set it to display transactions that run longer than 2 seconds, and cut down on alot of the non problematic ones.

Viewing 4 posts - 1 through 3 (of 3 total)

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