Summary information |
|
|---|---|
Default value |
4096 |
Range of values |
0 – 2147483647 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System administrator |
Configuration group |
SQL Server Administration |
Adaptive Server maintains a memory pool for the transfer table command and for tables marked for incremental transfer. This pool provides memory for maintaining state information about current and past transfers, and for memory used to write to and read from transfer files. transfer utility memory size determines the size of this memory pool.
The units for this pool are in memory pages, which are blocks of 2048 bytes. The default size is large enough to accommodate over 100 tables marked for incremental transfer, all transferring simultaneously.
If your installation does not include tables marked for incremental transfer, and does not use the transfer table command, you may set the size of this memory pool to zero to reclaim this memory.
