When working on different client servers, we often times get asked, why all their memory is not being used, and often times we are hitting the memory limits for SQL Server Standard Edition. Keep in mind that this limit on memory is for the buffer pool and what is being used by databases. SQL Server can use more than this …

SQL Server Memory Limits Read more »

Looking at the memory limits and other limits on the SQL Server versions over time, we have seen things increase, but one limit that is still very low is the memory limit for SQL Express. Specifically the maximum memory for buffer pool per instance of SQL Server Database Engine for SQL 2019. The limit there is 1410 MB. At first …

Memory Limit for SQL Server Express Read more »