These Colors Don’t Gum
While working with a client recently, I found it useful to illustrate how much of their memory was used by different memory consumers.
- Buffer pool
- Total other
- Top 5 other
It helps put in perspective just how many different things are asking for a piece of your precious RAM.
This is a bad example from my personal
server laptop, but you get the idea.
Anyway, that’s that. clink over to my GitHub repo to download it.
Thanks for reading!
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
- SQL Server Community Tools: The Wrap Up And Combined Link
- SQL Server Community Tools: Why Does sp_PressureDetector Make A Big Deal About The Remote DAC?
- SQL Server Community Tools: sp_PressureDetector Doesn’t Show You Irrelevant Waits
- SQL Server Community Tools: sp_PressureDetector Shows You Running Queries Taking Up CPU And Memory