SQL Server 2012/2014 insufficient memory available in the buffer pool We have bunch of SQL Server 2012 Standard and SQL Server 2014 Standard database instances running on Windows 2012, each have different storage and memory. We are getting:


  Error Code: 802; There is insufficient memory available in the buffer
  pool.


from 3 database servers when we build large SQL Server indexes, and it's happening intermittently, once in 3 or 4 months. The same indexes run fine on servers with same version of SQL Server and only 1/3 of memory and CPU.

SQL Server 2012 Standard Servers


Memory 110GB allocated out of 128 GB. Version 11.0.6 - We get reported the following error when we run heavy index:



  Error Code: 802; There is insufficient memory available in the buffer pool. 


Memory 78GB allocated to SQL out of 96GB. Version 11.0.6 - We get reported the following error when we run heavy index: 



  Error Code: 802; There is insufficient memory available in the buffer pool.


Memory allocated 18GB out of 24GB. VM. Version 11.0.5


No indexing error 

Memory 24GB out of 32GB. Physical. Version 11.0.5


No indexing error 



SQL Server 2014 Standard Servers


Memory 56GB out of 64GB physical memory. Version 12.0.5 - We get reported the following error when we run heavy index: 



  Error Code: 802; There is insufficient memory available in the buffer pool.


Memory 18GB out 24GB - VM. Version 12.0.5. 


No indexing error
I don't think there's much mystery to the the errors occurring with SQL 2012 Standard as that edition only supports 64GB of memory.  Set your max server memory to 64GB and this error should disappear for your SQL 2012 instances.

As for SQL 2014 Standard Edition, the max server memory limit increased to 128GB, so I'll echo Sean Gallardy's question in the comments and ask what else you're running on that VM or if you've over-provisioned the VM host by accident?