Post reply

Filtering Extended Events data

  • March 14, 2014 at 2:26 pm

    #396424

    Hello experts,

    Is there any way to set up an Extended Events session so that it captures events for only one database?

    If filtering by database is not possible, what are the options for reducing the size of the session as much as possible?

    The reason I ask is that it seems like Extended Events logs a lot of data. I'm trying to use Extended Events for a proposed upgrade to SQL Server 2012 to find features that are deprecated or discontinued in SQL 2012.

    Thanks for any help!

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • March 14, 2014 at 2:43 pm

    #1697326

    yes you can filter on Database_id or database_name, the same way you could with a server side trace.

    here's a screenshot using 2012's GUI to build an extended event session:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 14, 2014 at 3:11 pm

    #1697339

    Lowell (3/14/2014)

    yes you can filter on Database_id or database_name, the same way you could with a server side trace.

    here's a screenshot using 2012's GUI to build an extended event session:

    Thanks!

    Is anything like this available for SQL Server 2008 R2?

    Or do I need to install SQL 2012 (such as Developer Edition) in order to use database filters in the GUI for Extended Events on my pre-SQL 2012 databases?

    Thanks again!

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply