Post reply

Extended Events to capture the queries run against the changed tracking tables.

  • May 18, 2022 at 4:14 pm

    #4035073

    Hello Group,

    Do you have any available extended events to capture the queries run against the change tracking tables?

    Thanks.

  • May 19, 2022 at 12:12 pm

    #4035556

    It would be the standard stuff, sql_batch_complete or rpc_complete. With the batch completion event you can filter by the search string. With the rpc_complete you'll need to first identify stored procedures that query the tables you're interested in. Then use the object name or the object ID to filter.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply