Jon Gurgul's Blog

Tag: Log

  • Transaction Log Usage By Session ID

    —

    by

    Jon Gurgul
    in

    A script to show the log usage on a per session basis, which can be useful when determining the potential impact of a query. It can be good to know for example if a session has generated a lot of log entries, and therefore killing that sessions would take a substantial amount of time. I…

  • Suppress messages in SQL log

    —

    by

    Jon Gurgul
    in

    Previously we had looked at how to configure alerts to log the messages that we are interested in picking up. In this previous post I very briefly showed how to add logging for messages that were not normally logged such as a permission denied. But just as there are extra messages you want to see…