Query to monitor the activity from Mirroring

monitoring_extended_events.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'mirroringlotsoftables'  -- replace with your database
      --  AND sqlserver.sql_text LIKE '%tbl_%'  -- if you are just interested in a specific table
        AND sqlserver.username = N'YourAdminUser'  -- filter this to the user used to Mirror
    )
)
ADD TARGET package0.event_file
(
    SET filename = 'C:\XE\MonitorTableQueries.xel',
        max_file_size = 10,
        max_rollover_files = 50
)
WITH (
    MAX_MEMORY = 4096 KB,
    EVENT_RETENTION_MODE = ALLOW_SINGLE_EVENT_LOSS,
    MAX_DISPATCH_LATENCY = 30 SECONDS,
    TRACK_CAUSALITY = ON,
    STARTUP_STATE = OFF
);
GO

-- Start the session
ALTER EVENT SESSION [MonitorTableQueries] ON SERVER STATE = START;