How to See Rowcounts and Execution Time for In-Flight Queries in SQL Server
I frequently need to see rowcounts and execution time for queries while they’re running. Maybe I’m troubleshooting a slow query …
Read MoreConfigure Fields and Predicates for Multiple X-Events
By Kendra Little on • 1 min read
Category:
monitoring-troubleshooting
I’m not always the best at learning to use graphical interfaces. Maybe that’s why I often don’t like them?
The Discovery
I do rather like the Extended Events GUI – at least better than I like writing my own TSQL for Extended Events. And I finally figured out something that wasn’t obvious to me at all: it’s very easy to set global fields and predicates for multiple events!
How It Works
Here’s an animated GIF showing the magic of highlighting multiple events using the shift key:
Was this obvious to everyone else?
It only took me a few years to figure it out. :smile:
RELATED POSTS
