user7042812
Reputation: 133
Extended Events SQL Server Select Query
Which XEvents fire on simple select * from table query ? I want to test something and can't find easily testable XEvent.
Upvotes: 0
Views: 269
Answers (1)
Dan Guzman
Reputation: 46203
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.
Upvotes: 2
Related Questions
- Extended Event in Anaysis Service 2008
- How to start sql server extended events sessions using sql query
- SQL Server Extended events vs DMVs
- Creating EVENTS in SQL Server
- Event driven select statement
- SQL Server Query - Create New Events to Fill Gaps
- select events happening at the same time
- SQL eventdata()
- SQL Server Extended Events doesn't have the newer events
- Filter extended events by affected table?