Jon Gurgul's Blog

Tag: dm_exec_sessions

  • Most Recent SQL Query

    —

    by

    Jon Gurgul
    in

    Here is another query that is useful to have when you need to find out what everyone is up to. Or in some cases when we need to recover what was on someones ssms before they accidentally closed without saving work. 🙂

  • A simple what is running script aka a modern sp_who2

    —

    by

    Jon Gurgul
    in

    There is a great deal of information that can be gathered to show what is currently running on SQL Server, but sometimes simple and brief is best. So here is a quick overview gathering scripts with limited bells and whistles. The most important information for user requests is shown which can then be used to…