July 17, 2006 at 6:31 am
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 ?
July 17, 2006 at 9:03 am
Read up BOL for fn_get_sql() (this was introduced in SP3 for SQL 2000).
July 17, 2006 at 3:10 pm
Profiler is the quick answer.
Did you mean server side traces?
Regards,Yelena Varsha
July 18, 2006 at 7:34 am
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