Edit 1: From article posted by first answer > this:

Additionally, if you are using memory optimized table in the context of table valued parameters repeatedly, you may encounter this error even you use them in a separate batch and memory gets released. We are looking to address this issue in future cumulative updates. For now, you either need to use enterprise edition or periodically restart SQL or offline/online the database.

I use in-memory table valued parameters continually. However as a troubleshooting step, I re-deployed the solution and removed all memory optimization. I still received this error message. After restarting the service the message is gone and I'm able to use in-memory tables once again.

Original Post:

I'm receiving this message (Sql Server Standard 2016 sp1 on VM):

Could not perform the operation because the database has reached its quota for in-memory tables.

However, in-memory table usage is zero as shown here. Any idea how to recover from this state or even start to investigate what is going on?

enter image description here

  • Were you performing any operation/running any query when you got this error message? Where did you get this message? Was there any other message in the errorlog at the same time? – SqlWorldWide Sep 7 '17 at 0:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.