You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
There's a section in sp_PressureDetector that does this, and might be a good starting place if you need one. I remember being really annoyed with the amount of dynamic SQL necessary to make it compatible across older SQL Server versions.
Is your feature request related to a problem? Please describe.
A few different related issues:
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.
The text was updated successfully, but these errors were encountered: