SQL-Server-First-Responder-Kit icon indicating copy to clipboard operation
SQL-Server-First-Responder-Kit copied to clipboard

sp_BlitzFirst: add analysis of sys.dm_os_memory_clerks usage

Open BrentOzar opened this issue 10 months ago • 0 comments

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: Screenshot 2024-04-15 at 10 46 21 AM

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.

BrentOzar avatar Apr 15 '24 14:04 BrentOzar