I need to cover few scenarios related to SQL statements or procedures and their Execution plans and IO statistics:
- To monitor stored procedures performance running on server
-
To get execution plan from procedures not easily accessible from management studio
- Procedures called from Service Broker applications
- Complicated access to execution plan (Huge nested level of SQL statement – cursors)
- Compare batches in testing labs
I decided to use Extended Events as lightweight solution for such a scenario.