February 28, 2017 at 8:42 am
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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply