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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,367 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,136 Reputation points Microsoft Vendor
    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
  1. Erland Sommarskog 107.2K Reputation points
    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 No comments