Post reply

Reports for procedures that are in memory.

  • February 28, 2017 at 8:42 am

    #335688

    Sql 2016 offers Query store which shows all top resource consuming  sql queries and procedures for a database. Now this report is for objects that are existing at disk level. Are there any similar reports that shows such details for procedures that are 'In Memory'. I m mainly trying to get a report which will show the before and after results , when natively compiled procedures are moved into memory. thanks

  • February 28, 2017 at 9:02 am

    #1930728

    Natively compiled procedures aren't in memory. They're stored just like other stored procedures in the system tables, and then compiled into dlls as well. It's the In-memory tables which are in-memory.

    Query Store captures queries and plans for natively-compiled procedures the same as it does for interpreted T-SQL. You have to enable the capture of run-time execution characteristics, you can do that by running a system stored proc.
    The details are given in https://msdn.microsoft.com/en-us/library/mt590480.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

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