Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How viewing the Extended Events file in a GUI-style - SQL Server 2008 R2 Expand / Collapse
Author
Message
Posted Thursday, October 17, 2013 10:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 7:33 AM
Points: 84, Visits: 254
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
Post #1505802
Posted Sunday, November 24, 2013 2:07 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 9, 2014 12:08 PM
Points: 1,618, Visits: 1,553
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
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1517123
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse