Post reply

TimeProcessing suddenly spikes to 5 min (normal time = 90 milliseconds)

  • May 29, 2009 at 8:44 am

    #210066

    Once in a while [ExecutionLog.TimeProcessing]

    of a report suddenly spikes to 5 minutes (238639 milliseconds).

    Normally it's 90-100 milliseconds:

    TimeDataRetrieval TimePorcessing TimeRendering

    ----------------------------------------------------

    11990 70 18

    11690 90 46

    0 238639 0

    0 23 125

    8821 81 18

    9967 86 25

    What could have caused it?

  • May 29, 2009 at 8:57 am

    #1002099

    There must be some process blocking ur query to run this report probably, what does sp_who2 or sysprocesses looks like on this SPID when the slowness happens? What SPID does it shows blocking this query (if it does) when this happens?

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

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