• gtrennert - Wednesday, August 23, 2017 4:07 AM

    I will have a look to get something better, but not immediatly
    I first try to understand. - I created an extended event session (SQL Server 2014) but I don't know what kind of events to choose.
    I tried with query_pre_execution_plan / query_post_execution_plan / sql_statement_starting / sql_statement_completed, and saw nothing that inspired me
    But perhaps I should choose other event types ?
    I wonder if there is a possibility to filter in the session on events concerning a specified database. I did not see anything ...

    I'm afraid you'll need to do a bit of research to work out which event types to use.  I don't know off the top of my head.  Alternatively, use Profiler and run a trace.  Just know that (a) Profiler traces are deprecated (so you may prefer to invest the time now to learn Extended Events) and (b) Profiler uses more resources and so may have a more noticeable effect on server performance than Extended Events does.

    John