×

#Dataweekender-Virtual Popup Microsoft Data Conference

Date/Time: Saturday, October 17, 2020 11:25 - 11:35 EDT
Location: Virtual

View Event: Extended Event – How to collect the first 10 or every 4th event?

Extended Events offers a rich filtering mechanism, called predicates, that allows you to reduce the number of events you collect by specifying criteria that will be applied during event collection. By evaluating predicates early in the event firing sequence, we can reduce the performance impact of collecting events by stopping event collection when the criteria are not met. You can specify predicates on both event fields and on a special object called a predicate source. Applying predicates on predicate source you can customize your collection and answer the critical questions very quickly.

In this demo session, I will show you how you can collect only the nth number of events. You can also use this trick to stop a collection automatically when you are only looking for if an event is occurring or no?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

I want to talk about forgiveness and why no, white people, you are NOT entitled to it from Black people.

It's been ... around 72 hours since ten innocent people were brutally slaughtered for being Black and as usual when things like this happen, white comfort supersedes Black grief.

My good friend @SqlWorldWide is going to teach us new features SSMS at 6 30 pm EST today..not too late to sign ... up..https://www.meetup.com/tripass/events/285184740/?_xtd=gatlbWFpbF9jbGlja9oAJDQ3ODcxNjg5LTE5Y2EtNDJhYy05N2RiLTNiN2MzZjI0YzdkYg&_af=event&_af_eid=285184740

Happy Monday!! Hope you had a great weekend.

@dgmelkin will be talking about "Choosing the Right Tool for the Job"

... Wednesday May 25, 2022
3 PM EST

Registration:
https://www.meetup.com/dbavug/events/285507807/

#tools #dataplatform #mvpbuzz

I will be speaking at Triangle SQL Server User Group.

New features in Management Studio — Performance Troubleshooting... made easier!

Tuesday, May 17, 2022
6:30 PM to 8:30 PM EDT

Registration:
https://www.meetup.com/tripass/events/285184740/

#ssms #performance #sqlserver #MVPBuzz

Load More...