How can we help you today? How can we help you today?

Long query is incomplete.

Response alert some long query.
I find it, double click on process and show me fragmented query.
Same time I was running Profiler, so I find complete query to optimize.

Would be great to see in Response all the query to avoid Profiler.
I'm not said to replace Profiler, just to accelerate the analysis process.
Luis Martin
0

Comments

4 comments

Sort by
  • Nigel Morse
    Hi,
    Which version of SQL Server are you running?

    On 2000 we can only get the "input buffer" of the running SQL which may only be the first 255 bytes or so. If it's 2005 then it should have more (i think up to 8Kb)

    Perhaps you put the fragment and complete queries into a pm to me here?

    Thanks,
    Nigel
    Nigel Morse
    0
  • Luis Martin
    Hi,

    SQL 2000 SP4 Fix 2040.

    Unfortunately I've deleted that long query.

    Since I'm free lance DBA, I'll try with other customer on Sunday and back with that information.

    Other suggestion: Most of the times long queries belong to Response.
    Is there any way to avoid that?.
    I mean something like Profiler (don't show profiler itself time)
    Luis Martin
    0
  • Nigel Morse
    Hi Luis - I'd be interested to know which of Response's queries are comming up as long - could you perhaps send me the SQL that comes up for them in a pm please?

    Profiler doesn't show itself as it doesn't really run SQL once it's set up the trace it just sits there and listens. By contrast we're actually interrogating the server occasionaly to get information out of it.

    Now obviously we should be having minimal impact on a server, but if we just filtered out all our own queires then this may give a false picture - i'd rather we heard about them so we can fix it properly.

    Thanks,
    Nigel
    Nigel Morse
    0
  • Luis Martin
    Done.


    Luis
    Luis Martin
    0

Add comment

Please sign in to leave a comment.