Share via

What Name from Event Library?

JJ TT 141 Reputation points
2020-12-14T21:57:49.583+00:00

I'm new in SQL Server's extended events and you can create your own session and select your own name in Event library.

From your experience, what name from event library have you selected in order to faciliate your work or similar?

Thank you!

48164-ddd.jpg

SQL Server | Other
0 comments
Accepted answer
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2020-12-15T02:47:51.553+00:00

    Hi @JJ TT ,

    >what name from event library have you selected in order to faciliate your work or similar?

    It depends on your requirement. When you create an extended event session, you tell the system:
    •Which occurrences you are interested in.
    •How you want the system to report the data to you.

    You can type the name or description about your requirement in Event library as below screenshot( trace SQL statement) to filter what you want, check the description about the event by clicking the event, then choose the event that you want.

    48137-screenshot-2020-12-15-103829.jpg

    Suggest you start from this MS document Quickstart: Extended events in SQL Server.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
    2020-12-14T22:37:04.593+00:00

    That all depends on what you are looking for. There is a myriad of extended events, and you cannot blame them for being overly documented. To find a certain event, you need to type some word you expect to find in the event name and hope the filter finds something.

    Personally, I find Extended Events hopelessly over-engineered, and I only use it, if I need something which I can't do with Trace, which is easier to use, easier to analyse and is better documented.

    I did however sometime back compose an X-event session to capture exceptions in a database, and I have an article about this here:
    http://www.sommarskog.se/Short%20Stories/trace-exceptions.html

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.