The January 2009 issue of TechNet Magazine is now available on the web and has a new article I wrote on Advanced Troubleshooting with Extended Events in SQL Server 2008. The article covers:
An overview of extended events, with descriptions of all the parts of the feature and how to investigate them with the new DMVs
Performance considerations of how you setup an extended events session, especially on multi-core servers
An example where I build an I/O chargeback mechanism to tie into a system controlled by the SQL Server 2008 resource governor
You can get to the article here, which also has a link to a screencast of me doing a demo. And you can bet that this is an area I’ll be blogging about going forward too.
PS This issue also has the editorial where I get made a Contributing Editor :-)