Sunday, March 05, 2017

Memory Exception with SQL Server queries

Hi,

I have tried to benchmark the SQl Server vs SQL Service InMemory tables vs. Redis,
and got a weird error while intensively working with InMemory tables:
System.Data.SqlClient.SqlException: There is insufficient system memory in resource pool 'default' to run this query
The data volumes were absolutely reasonable

It appeared that to fix it we need to limit the SQL Server memory!:) Otherwise it tries to use memory over available.