• j.a.c (3/27/2013)


    Hi,

    Are there any sessions that have been running for a long time? Any by long time I mean running for days.

    Yep, first thing to look.

    Faced the same problem some time ago.

    Turned out it was a bug in the application - closing opening connection "conn" in try, and closing "conn1" in catch.

    Because the issue happened only after an exception in that particular piece of functionality it was also totally random, with no pattern to be found.

    Try to match the timing of tempdb issues with exceptions recorded in the application log.

    _____________
    Code for TallyGenerator