Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

sys.sp_xtp_unbind_db_resource_pool (Transact-SQL)

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.

Topic link icon Transact-SQL Syntax Conventions

Applies to: SQL Server (SQL Server 2014 through current version).

sys.sp_xtp_unbind_db_resource_pool 'database_name'

database_name

The name of an existing In-Memory OLTP enabled database.

If database was bound to a named resource pool, the procedure returns successfully. However, You must restart the database for unbinding to take effect.

If there is no existing binding for the database specified, sp_xtp_unbind_db_resource_pool returns success, but gives the informational message:

Msg 41374, Level 16, State 1, Procedure sp_xtp_unbind_db_resource_pool_internal, Line 140.
Database 'Hekaton_DB' does not have a binding to a resource pool.

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.

sys.sp_xtp_unbind_db_resource_pool 'Hekaton_DB'

  • The database specified by database_name must have a binding to an In-Memory OLTP resource pool.

  • Requires CONTROL SERVER permission.

Community Additions

ADD
Show:
© 2015 Microsoft