Script to setup an extended events trace for SQL Mirroring

MirroringEventTrace.sql

-- Create Extended Events session
CREATE EVENT SESSION [MonitorTableQueries]
ON SERVER
ADD EVENT sqlserver.sql_statement_completed
(
    ACTION (
        sqlserver.sql_text,
        sqlserver.database_name,
        sqlserver.username
    )
    WHERE (
        sqlserver.database_name = N'YourDatabaseName'
        AND sqlserver.sql_text LIKE '%YourTableName%'
        AND sqlserver.username = N'YourUserName'
    )
)
ADD TARGET package0.event_file
(
    SET filename = 'C:\XE\MonitorTableQueries.xel',
        max_file_size = 50,
        max_rollover_files = 5
)
WITH (
    MAX_MEMORY = 4096 KB,
    EVENT_RETENTION_MODE = ALLOW_SINGLE_EVENT_LOSS,
    MAX_DISPATCH_LATENCY = 30 SECONDS,
    TRACK_CAUSALITY = ON,
    STARTUP_STATE = OFF
);
GO