Post reply

How viewing the Extended Events file in a GUI-style - SQL Server 2008 R2

  • October 17, 2013 at 10:16 am

    #395683

    Hi,

    I'm using the Extended Events to monitor query perfomance in a SQL Server 2008 R2 instance, producing a file as a target.

    I'd like to view the collected data in the file in an easy manner by a GUI-Style.

    How can I do it?

    Thanks

  • November 24, 2013 at 2:07 pm

    #1668689

    Use sys.fn_xe_file_target_read_file() to read the file in from SSMS to output its data and query it like a table.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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