Yesterday I was working on a SSMS SQLCMD-mode script and I noticed that periodically my session_id changed across test executions. I was tracking wait statistics based on specific session IDs, so I had to periodically add new session ids to my extended events session definition to make sure I captured my session’s wait stats accordingly. […]