The typical consumer of agent private memory is the sort heap memory that is used by the agent to sort rows during query execution.
代理私有内存的常见消费者是排序堆内存,代理在查询执行期间使用这部分内存来对记录行进行排序。
A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.
缓冲池是内存中的一块存储区域,用于临时读入和更改数据库页(包含表行或索引项)。
The amount of virtual Shared memory that the database server allocates for a sort depends on the number of rows to be sorted and the size of the row, and whether PDQPIORIDY is set for the server.
数据库服务器分配给排序的虚拟共享内存的数量取决于要进行排序的行数、每一行的大小以及是否为服务器设置了PDQPIORIDY。
应用推荐