February 7, 2017 at 1:19 am
Hi!
Could someone please help me create a query all extended events and their status in all servers?
Thanks in advance!
February 7, 2017 at 4:35 am
Take a look it this URL - https://www.sqlskills.com/blogs/jonathan/extended-events-dmvs/ It contains all the information that you need in order to create such a query.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 7, 2017 at 6:19 am
BiboKid - Tuesday, February 7, 2017 1:19 AMHi!Could someone please help me create a query all extended events and their status in all servers?
Thanks in advance!
Wait, You don't enable or disable all extended events. You have Extended Event Sessions. Those sessions contain events and those sessions are enabled or disabled. From the question, it sounds like you're thinking about this wrong. What exactly are you actually trying to do?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply