Post reply

SQL Cached Plans - MPA

  • March 12, 2013 at 7:30 am

    #1596007

    opc.three (3/12/2013)

    Where did you learn about SPA/MPA?

    Web mostly

  • March 12, 2013 at 7:59 am

    #1596022

    I could find nothing in my 2008 Internals book (Delaney) that would explain the difference. The differences are odd but are nothing that I expect will ever affect how I admin or develop for SQL Server...what about you?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 12, 2013 at 8:07 am

    #1596031

    . The differences are odd but are nothing that I expect will ever affect how I admin or develop for SQL

    I agree - More than anything else, I just want to make sure that my understanding is correct

    At least with SQL 2012, AFAIK, MPA is gone

    Thanks

  • March 12, 2013 at 8:15 am

    #1596036

    That's my understanding as well. All memory allocation is now coming from the same allocator and the best known side-effect of that change is that the 'max server memory' option now governs all memory SQL Server allocates, not just the buffer pool.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 12, 2013 at 8:20 am

    #1596039

    Thanks for your help

Viewing 5 posts - 16 through 19 (of 19 total)

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