Post reply

Converting job_id to join to another table.

  • December 5, 2024 at 6:06 pm

    #4493797

    So to clarify a few things, I used sp_who2 as an example anyone could do. What is really happening is we are logging trace data on blocking events and long-running transactions into tables that we query later. Sadly, that means sys.dm_exec_sessions doesn't work because many of those sessions might be long past.

    And those that aren't are a whole nother issue.

    Thank you all for your thoughts.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • December 5, 2024 at 6:08 pm

    #4493799

    Dup post

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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