Post reply

New DMVs in 2014

  • April 9, 2014 at 10:37 am

    #306531

    A list of the new DMVs in 2014 and how they are useful.

  • May 6, 2014 at 9:25 am

    #1711131

    bump.

    Not just a list. Include information about what is contained in each and how it might be used.

    If these are changes from 2012 to existing items, you can leave them out or make a second article.

  • May 9, 2014 at 9:40 am

    #1712244

    I just submitted an article about changes in 2012 DMVs...if this is good, I can create one for SQL Server 2014 in a similar format and take this one.

  • May 12, 2014 at 11:53 am

    #1712806

    Ed, that looked good on 2012. Closing that thread.

  • May 12, 2014 at 11:55 am

    #1712807

    Steve Jones - SSC Editor (5/12/2014)

    Ed, that looked good on 2012. Closing that thread.

    OK---sounds good, I'll do the same for 2012 vs. 2014 and submit when it's all together!

  • May 12, 2014 at 4:10 pm

    #1712874

    It would also be cool to identify any DMVs that have been deprecated or discontinued, if there are any. If there are none, that would be good to know, as well. Thanks.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 12, 2014 at 6:20 pm

    #1712883

    Jeff Moden (5/12/2014)

    It would also be cool to identify any DMVs that have been deprecated or discontinued, if there are any. If there are none, that would be good to know, as well. Thanks.

    Sure---can definitely add that in---the biggest additions in 2014 relate to in-memory OLTP stuff, so outside of that there will be space to talk about other things. No DMVs were removed as far as I can tell, and I have not checked for deprecation (but will).

  • May 12, 2014 at 10:41 pm

    #1712893

    Very cool. That'll make an awesome article. Thanks, Ed.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply