This week, after seeing a lot of the DMV enhancements made in SQL Server 2008 R2 SP1, I thought I would take a look at some dynamic management view/function requests.
Page split personality Michael Zilberstein blogged on Monday about how Extended Events and the transaction log differ in the way they report page split information, and that it ...

On Friday, after Microsoft released the CTP, I talked a little bit about the changes you will see in SQL Server 2008 R2 SP1. Namely:
new rowcount-related columns in sys.dm_exec_query_stats;
extended functionality of the FORCESEEK query hint;
a new FORCESCAN query hint;
support for 15,000 partitions (to match new ...

In a previous post about changed system objects in Denali, I talked about the changes to memory-related DMVs due to underlying changes in the memory manager. The SQLOS team has posted a great introduction to these changes, and they plan to post more details in future posts. In the meantime, and due to a question yesterday from Tom ...

While it's still only the CTP1 timeframe, getting a glimpse of the changes in system objects can start preparing you for what's coming - especially when there are potential breaking changes, as you'll see below. Sure, a few of these things can change (and hopefully be fixed!) as the product gets closer to release, but once you have the ...

I have been involved in several discussions over the past week involving getting more diagnostic information out of the DMVs in SQL Server 2008 and beyond.
Yesterday, I asked for procedure recompiles to be tracked in the new sys.dm_exec_procedure_stats DMV:
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=388218
Today, ...