What Name from Event Library?

Question

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!

Answer 1

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.

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.

Answer 2

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