New DMV–yes… no… that’s complicated

Posted by Michael Zilberstein on SQL Blog See other posts from SQL Blog or by Michael Zilberstein
Published on Thu, 17 Oct 2013 00:34:54 GMT Indexed on 2013/10/17 16:17 UTC
Read the original article Hit count: 202

Filed under:
|
Remember the excitement about new sys.dm_exec_query_profiles DMV? It promised to be a gamechanger, providing query visibility at a runtime and easily extractable information about heavy iterators in execution plan. So it has been announced but missing. Now in CTP2 it is finally here. So, singing one of my favorite Queen songs “… It finally happened - I’m slightly mad…” , I tried to observe query execution data at a runtime. And… nothing. Query is running, DMV is empty. That’s really disappointing...(read more)

© SQL Blog or respective owner

Related posts about Performance

Related posts about SQL2014

  • New DMV… not yet

    as seen on SQL Blog - Search for 'SQL Blog'
    Downloaded and installed new toy: And while reading BOL, stumbled upon new extremely useful DMV: sys.dm_exec_query_profiles . This DMV enables DBA to monitor query progress while it is being executed. Counters in the DMV are per operation per thread. So we’ll be able to monitor in real time which… >>> More

  • Delayed Durability–I start to like it!

    as seen on SQL Blog - Search for 'SQL Blog'
    In my previous post about the subject I’ve complained that according to BOL , this feature is enabled for Hekaton only. Panagiotis Antonopoulos from Microsoft commented that actually BOL is wrong – delayed durability can be used with all sorts of transactions, not just In-Memory ones. There is a database-level… >>> More

  • sys.dm_exec_query_profiles – FAQ

    as seen on SQL Blog - Search for 'SQL Blog'
    As you probably know, this DMV is new in SQL Server 2014. It had been first announced in CTP1 but only in BOL . Now in CTP2 everyone can “play” with it. Since BOL is a little bit unclear (understatement detected), I’ve prepared this small FAQ as a result of discussion with Adam Machanic ( blog | twitter… >>> More

  • SQL Server 2014 – delayed transaction durability

    as seen on SQL Blog - Search for 'SQL Blog'
    As I’m downloading SQL Server 2014 CTP2 at this very moment, I’ve noticed new fascinating feature that hadn’t been announced in CTP1 : delayed transaction durability . It means that if your system is heavy on writes and on another hand you can tolerate data loss on some rare occasions – you can consider… >>> More

  • Updatable columnstore index, sp_spaceused and sys.partitions

    as seen on SQL Blog - Search for 'SQL Blog'
    Columnstore index in SQL Server 2014 contains 2 new important features: it can be clustered and it is updateable. So I decided to play with both. As a “control group” I’ve taken my old columnstore index demo from one of the ISUG (Israeli SQL Server Usergroup) sessions. The script itself isn’t important… >>> More