Friday I’m Not Here
This is a short post to warn you about the memory recommendation tab in the SQL Server installer.
Let’s say you’re doing the smart thing and giving your Standard Edition install 192 GB of RAM:
Why is this smart? Because Standard Edition’s 128GB memory limit is only on the buffer pool. SQL Server can use memory over and above that for other stuff, like:
- Query memory grants
- Compressed backups
- Other caches/Lock memory, etc.
The problem is that the installer’s recommendation only reflects the buffer pool limit. It doesn’t actually consider that memory can get used over that, and you end up with this recommendation:
That’s 128GB exactly, which is daft to the back teeth.
The number I usually start with here is 184320, which is 180GB. That gives Windows about 12GB to work with.
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.