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

2 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

Leave a Reply

Your email address will not be published.