Extended Events is a very powerful new feature of SQL Server 2012. The best thing about this is that its so powerful, yet very lightweight (in terms of resource utilization) and extremely easy to set up and use.
Except for one gotcha.
I had set up an Extended Events session and fired it up. A few minutes later, it was still showing “retrieving event information from server” and the panes were empty. What was wrong? Why wasnt it populating data?
I had a hunch and changed the case of the database name filter. Bingo!
Here in the SQL Server world, we are used to typing away without checking uppercase / lowercase. This was the issue. A small thing, but knowing this can help avoid going after unnecessary code checks!