Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gianluca Sartori TempDB usage per active session RE: TempDB usage per active session

  • April 23, 2016 at 4:42 pm

    #1874111

    Thanks so much for this query. Is there a similar one for retrieving tempdb log space used per SPID?

    I'd like to track such a query for an issue where an as-yet unknown query is causing periodic large increases in the percent of log space used.

    Thanks for any help!

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html