Kbase P47640: Why does the _sqlsrv2 process not release the memory back to the operating system?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/09/2009 |
|
Status: Unverified
GOAL:
Why does the _sqlsrv2 process not release the memory back to the operating system?
GOAL:
Why doesn't the _sqlsrv2 process release the memory back to the OS ?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The _sqlsrv2 process uses a memory pooling mechanism for memory allocated to process and execute queries. Memory space is allocated to grow the pool and then is available to be reused when it is de-allocated. This is a performance optimization which is done per process.
Statement caching is something that will delay a request to make areas of memory within the pool reusable, which can account for growth in memory used by the server.
Schema caching is something else that can account for growth in memory used by the server.