Skip to content

Commit 52390a8

Browse files
authored
Merge pull request MicrosoftDocs#6704 from dbaduck/patch-15
Update bind-a-database-with-memory-optimized-tables-to-a-resource-poo…
2 parents 3570a5f + 3bf09d2 commit 52390a8

1 file changed

Lines changed: 3 additions & 3 deletions

File tree

docs/relational-databases/in-memory-oltp/bind-a-database-with-memory-optimized-tables-to-a-resource-pool.md

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -141,7 +141,7 @@ GO
141141

142142
1. Use `ALTER RESOURCE POOL` to change the value of both MIN_MEMORY_PERCENT and MAX_MEMORY_PERCENT.
143143

144-
2. Use `ALTER RESURCE GOVERNOR` to reconfigure the Resource Governor with the new values.
144+
2. Use `ALTER RESOURCE GOVERNOR` to reconfigure the Resource Governor with the new values.
145145

146146
**Sample Code**
147147

@@ -170,7 +170,7 @@ GO
170170
|\<= 96 GB|85%|
171171
|>96 GB|90%|
172172

173-
For example, if your 'target committed memory' is 100 GB, and you estimate your memory-optimized tables and indexes need 60GBof memory, then you can create a resource pool with MAX_MEMORY_PERCENT = 67 (60GB needed / 0.90 = 66.667GB - round up to 67GB; 67GB / 100GB installed = 67%) to ensure that your [!INCLUDE[hek_2](../../includes/hek-2-md.md)] objects have the 60GB they need.
173+
For example, if your 'target committed memory' is 100 GB, and you estimate your memory-optimized tables and indexes need 60GB of memory, then you can create a resource pool with MAX_MEMORY_PERCENT = 67 (60GB needed / 0.90 = 66.667GB - round up to 67GB; 67GB / 100GB installed = 67%) to ensure that your [!INCLUDE[hek_2](../../includes/hek-2-md.md)] objects have the 60GB they need.
174174

175175
Once a database has been bound to a named resource pool, use the following query to see memory allocations across different resource pools.
176176

@@ -195,7 +195,7 @@ pool_id Name min_memory_percent max_memory_percent max_memory_mb used
195195
----------- ----------- ------------------ ------------------ ------------- -------------- ----------------
196196
1 internal 0 100 3845 125 3845
197197
2 default 0 100 3845 32 3845
198-
259 PoolIMOLTP 0 100 3845 1356 2307
198+
259 Pool_IMOLTP 0 100 3845 1356 2307
199199
```
200200

201201
For more information, see [sys.dm_resource_governor_resource_pools (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-resource-governor-resource-pools-transact-sql.md).

0 commit comments

Comments
 (0)