Instead of trying to trick out how extended events works, simply expose the data collected in a different location, a file system or something. What's important is not running Extended...

If you're capturing queries, usually either rpc_completed or sql_batch_completed, you'll be getting all queries. Then just filter by the appropriate action and values to limit the queries to a particular...

To do this you're going to need to use an Action in the events you capture. Which action really depends on your system setup. You can use username, session_principal_name, nt_user_name,...

It's all Steve Jones. His idea. His execution. He deserves all the credit.

Yep. You're stuck. Either all the values are the same, then no update should occur and no change tracking needed, or, the data is inserted only, and no way to...

No arguments. Your interpretation may be right. But then, what are we trying to see here? Query performance but not queries? How then do you correlate the performance, "An unidentified...

It is possible for Extended Events to miss an event. The tool is designed so that it puts minimal load on a system. Part of that includes the ability to...

Yes!

Have you tested without the nonclustered index? If it's not used, why have it at all? And yeah, lots of inplace updates are very hard on a columnstore index. Everything...

Thank you Grant Fritchey!

1. how can we check the cache for DMVs and  how to set the cache for DMVs( or how to set the cache for different DMVs)...

Best of luck. If you have some spare time, please build me a tool that easily, simply, and quickly, subsets data for test systems with minimal customization or programming. Thanks!

Hi,

Thanks for the suggestion. I created the extended event successfully but while accessing it , it is throwing me the error: "The storage failed to initialize using the provided...

Please, please, please, no politics. I just wanted to encourage people to learn a little history, either their own or others. That's all.

If it was an oopsie, just say it was an oopsie. You don't have to go into lots of detail on a thing like this. That is, unless they want...

Yeah, I'm a little surprised by this one too. I love my country....