An XEvent a Day (4 of 31) – Querying the Session Definition and Active Session DMV’s

Posted by Jonathan Kehayias on SQL Blog See other posts from SQL Blog or by Jonathan Kehayias
Published on Sat, 04 Dec 2010 14:00:00 GMT Indexed on 2010/12/06 16:58 UTC
Read the original article Hit count: 726

Yesterdays post, Managing Event Sessions , showed how to manage Event Sessions in Extended Events Sessions inside the Extended Events framework in SQL Server. In today's post, we’ll take a look at how to find information about the defined Event Sessions that already exist inside a SQL Server using the Session Definition DMV’s and how to find information about the Active Event Sessions that exist using the Active Session DMV’s. Session Definition DMV’s The Session Definition DMV’s provide information...(read more)

© SQL Blog or respective owner

Related posts about Extended Events

Related posts about SQL Server 2008