Managing Query Compilation Memory Consumption to Improve DBMS Throughput

Details Managing Query Compilation Memory Consumption to Improve DBMS Throughput Managing Query Compilation Memory Consumption to Improve DBMS Throughput

2006-12-21

arxiv.org/abs/cs/0612112v1

Computer Science

Databases

This article is published under a Creative Commons License Agreement (http://creativecommons.org/licenses/by/2.5/.) You may co

Scientific paper

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.

Affiliated with

Also associated with

No associations

Rating

Managing Query Compilation Memory Consumption to Improve DBMS Throughput does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with Managing Query Compilation Memory Consumption to Improve DBMS Throughput, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Managing Query Compilation Memory Consumption to Improve DBMS Throughput will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-531017