SQL-Server-First-Responder-Kit
SQL-Server-First-Responder-Kit copied to clipboard
sp_BlitzFirst: add analysis of sys.dm_os_memory_clerks usage
Is your feature request related to a problem? Please describe. A few different related issues:
- The plan cache, query workspace, In-Memory OLTP, or memory-optimized TempDB consumes a large amount of memory
- The buffer pool consumes a small percentage of memory
- Total amount of pages_kb is higher than max server memory (this one is a little tricky, and probably need to build a repro query)
Grabbing a screenshot of with In-Memory OLTP consuming 4.3GB (memoryclerk_xtp, db_id_2) just for reference, not that 4.3GB is a problem:
Describe the solution you'd like We've already got one check on sys.dm_os_memory_clerks for the user and token perm cache issue, but I'd like to expand that to a few other situations.
Describe alternatives you've considered Drinking. I'm still tempted by that alternative.
Are you ready to build the code for the feature? Yes.