Hello Geeks and welcome to the Day 60 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful DMVs in SQL Server. As we go ahead in this series we will also talk about the usage, linking between DMVs and some scenarios where these DMVs will be helpful while you are using SQL Server. For the complete list in the series please click here.

Since I started this series has come a long way and is completing two months. This is twice of any one day series so far. This is like a double century in cricket. I feel like Sachin Tendulkar, the god of cricket, when he did the first double century in first class cricket. Enough of cricket and let’s get to today’s blog. I will be covering sys.dm_xe_session_object_columns.

Yesterday we have seen sys.dm_xe_sessions which gives a single row with properties of a session. Sys.dm_xe_session_object_columns gives the configuration values set for each object bound to the session. Let us create the below session and check the output of sys.dm_xe_session_object_columns.

Now running select on sys.dm_xe_session_object_columns will get us the below result.


From the above results you can see the values set for each configurable columns in the session. If you observe correctly I have set the configurable object columns collect_object_name and collect_statement to non-default Boolean values. The same is shown in the output from sys.dm_xe_session_object_columns highlighted columns.

Tomorrow I will be covering another extended events related DMV. So stay tuned. Till then

Happy Learning,

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook |
Follow me on Twitter | Follow me on FaceBook