Xevents part 1: Analysing the System Health Session

Many DBA’s still rely on Profiler, despite the fact that Profile can track 200 events while Extended Events can have almost 900. The deprecated Profiler is not developed anymore and cannot cope with the new kids on the block, such as Availability Groups and Azure.

Time to show the power of Extended Events. In this first video, we’ll see how to group and filter events, check out the deadlock graphs, check for waitsstats during stressmoment. All from the default Extended Events trace, the System Health Session.

No configuration or programming yet – just the tour of functionalities.

 Click for Video

9 thoughts on “Xevents part 1: Analysing the System Health Session

  1. Long time reader, first time commenter — so, thought I’d drop
    a comment.. — and at the same time ask for
    a favor.

    Your wordpress site is very simplistic – hope you don’t mind me asking what theme
    you’re using? (and don’t mind if I steal it? :P)

    I just launched my small businesses site –also built in wordpress like yours–
    but the theme slows (!) the site down quite a bit.

    In case you have a minute, you can find it by
    searching for “royal cbd” on Google (would appreciate any
    feedback)

    Keep up the good work– and take care of yourself during the coronavirus scare!

    ~Justin

  2. When someone writes an post he/she keeps the thought of
    a user in his/her brain that how a user can be aware of it.
    Thus that’s why this post is perfect. Thanks!

  3. Someone essentially assist to make severely articles I would state.
    That is the first time I frequented your website page and so far?
    I amazed with the research you made to create this actual put up amazing.
    Excellent job!

  4. Hi! I know this is somewhat off topic but I was wondering which blog platform are you
    using for this site? I’m getting sick and tired of WordPress because I’ve had problems with hackers and I’m looking at alternatives
    for another platform. I would be great if you could point me in the direction of a good platform.

  5. Hey! Would you mind if I share your blog with my
    twitter group? There’s a lot of folks that I think
    would really enjoy your content. Please let me know.

    Many thanks

  6. I am not sure where you are getting your information, but great topic.
    I needs to spend some time learning more or understanding
    more. Thanks for magnificent information I was looking for this information for my mission.

Leave a Reply

Your email address will not be published.