Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
This system procedure removes an existing binding between a database and a resource pool for purposes of tracking In-Memory OLTP memory usage. If there is no pool currently bound to the specified database, success is returned. When the database is unbound, the previously allocated memory for memory-optimized objects stays allocated to the previous resource pool. You need to restart the database to free up the allocated memory. Once a database is unbound from the resource pool, the binding resorts to the DEFAULT resource pool.
Applies to: SQL Server (SQL Server 2014 through current version).
The following code unbinds the database Hekaton_DB from the In-Memory OLTP resource pool it is bound to. If Hekaton_DB is not currently bound to a In-Memory OLTP resource pool, a message is given. The database must be restarted for the unbinding to take effect.