Extended Events SQL Server Select Query

Question

Which XEvents fire on simple select * from table query ? I want to test something and can't find easily testable XEvent.

score 2 · Accepted Answer · answered Nov 01 '16 at 10:44

2

The sql_batch_starting and sql_batch_completed events will capture an ad-hoc query. Parameterized queries can be captured with rpc_starting and rpc_completed.

answered Nov 01 '16 at 10:44

Dan Guzman

43,250
3
46
71

Thanks, this is what I have been looking for ! – user7042812 Nov 01 '16 at 11:19

Extended Events SQL Server Select Query

1 Answers1