sys-sp-xtp-unbind-db-resource-pool-transact-sql.md

title	sys.sp_xtp_unbind_db_resource_pool (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_xtp_unbind_db_resource_pool_TSQL sp_xtp_unbind_db_resource_pool sys.sp_xtp_unbind_db_resource_pool_TSQL sys.sp_xtp_unbind_db_resource_pool
dev_langs	TSQL
helpviewer_keywords	sp_xtp_unbind_db_resource_pool sys.sp_xtp_unbind_db_resource_pool
ms.assetid	695a796d-087e-4bc8-99d0-ddc342604c75
author	stevestein
ms.author	sstein

sys.sp_xtp_unbind_db_resource_pool (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2014-xxxx-xxxx-xxx-md]

This system procedure removes an existing binding between a database and a resource pool for purposes of tracking [!INCLUDEhek_2] 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.

Transact-SQL Syntax Conventions

Syntax

sys.sp_xtp_unbind_db_resource_pool 'database_name'  

Arguments

database_name
The name of an existing [!INCLUDEhek_2] enabled database.

Parameters

Messages

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.  
  

Example

The following code unbinds the database Hekaton_DB from the [!INCLUDEhek_2] resource pool it is bound to. If Hekaton_DB is not currently bound to a [!INCLUDEhek_2] 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'  

Requirements

• The database specified by database_name must have a binding to an [!INCLUDEhek_2] resource pool.

• Requires CONTROL SERVER permission.

See Also

Bind a Database with Memory-Optimized Tables to a Resource Pool
sys.sp_xtp_bind_db_resource_pool (Transact-SQL)