Blog Archives

Capturing session level options settings on all sessions in SQL 2012 using XEvents


You could use XEvents to capture options set at all existing sessions & any future new sessions. Here is sample session definition. (I have tested it on SQL 2012 SP1). Please replace the file path in the following script to

Posted in SQL Server, XEvents