arXiv cs/06121122006-12-21cs.DB

管理查询编译内存消耗以提高DBMS吞吐量

Managing Query Compilation Memory Consumption to Improve DBMS Throughput

Boris Baryshnikov, Cipri Clinciu, Conor Cunningham, Leo Giakoumakis, Slava Oks, Stefano Stefani

备注：: This article is published under a Creative Commons License Agreement (http://creativecommons.org/licenses/by/2.5/.) You may copy, distribute, display, and perform the work, make derivative works and make commercial use of the work, but, you must attribute the work to the author and CIDR 2007. 3rd Biennial Conference on Innovative Data Systems Research (CIDR) January 710, 2007, Asilomar, California, USA

摘要：

虽然在数据库页面缓冲池和查询执行内存分配策略之间存在已知的性能权衡，但很少有人写过查询编译内存使用对数据库管理系统（DBMS）的整体吞吐量的影响。我们提出了一个新的方面的查询优化问题，并提供了一个解决方案，在Microsoft SQL Server 2005中实现。该解决方案为各种工作负载提供稳定的吞吐量，即使内存请求超出了硬件为这些请求提供服务的能力。

英文摘要：

While there are known performance trade-offs between database page buffer pool and query execution memory allocation policies, little has been written on the impact of query compilation memory use on overall throughput of the database management system (DBMS). We present a new aspect of the query optimization problem and offer a solution implemented in Microsoft SQL Server 2005. The solution provides stable throughput for a range of workloads even when memory requests outstrip the ability of the hardware to service those requests.

机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。

摘要：

英文摘要：

相关论文

符合新年龄要求的OTT平台的拟定DBMS

走向生态友好的数据库管理系统