Managing Query Compilation Memory Consumption to Improve DBMS Throughput

Summary: Identifies query compilation memory as a distinct, throughput-critical resource whose contention can throttle DBMS performance beyond buffer-pool/execution trade-offs. Describes a SQL Server 2005 implementation that throttles and queues compilations to stabilize throughput under memory pressure. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 85
Venue: CIDR
Year: 2007
Pagerank: 5.093636e-05
Overall Rank: 12,621 | 13.41%
DOI: -

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Boris Baryshnikov (Microsoft)
2. Cipri Clinciu (Microsoft)
3. Conor Cunningham (Microsoft)
4. Leo Giakoumakis (Microsoft)
5. Slava Oks (Microsoft)
6. Stefano Stefani (Microsoft)

BibTeX Citation

@inproceedings{baryshnikov_cidr07,
        address = {Amsterdam, Netherlands},
        series = {{CIDR} '07},
        title = {{Managing Query Compilation Memory Consumption to Improve DBMS Throughput}},
        booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
        author = {Baryshnikov, Boris and Clinciu, Cipri and Cunningham, Conor and Giakoumakis, Leo and Oks, Slava and Stefani, Stefano},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 3 of 3 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
1,917	Integration of Buffer Management and Query Optimization In Relational Database Environment	1989	VLDB	9.4864975e-05
2,184	Managing Memory to Meet Multiclass Workload Response Time Goals	1993	VLDB	9.0045033e-05
2,360	Dynamic Memory Allocation for Multiple-Query Workloads	1993	VLDB	8.6956893e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,837	Database Buffer Size Investigation for OLTP Workloads	1997	SIGMOD
2	2,360	Dynamic Memory Allocation for Multiple-Query Workloads	1993	VLDB
3	9,612	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR
4	434	Query Optimization for Parallel Execution	1992	SIGMOD
5	2,184	Managing Memory to Meet Multiclass Workload Response Time Goals	1993	VLDB
6	1,355	Query Processing in Main Memory Database Management Systems	1986	SIGMOD
7	1,917	Integration of Buffer Management and Query Optimization In Relational Database Environment	1989	VLDB
8	109	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB
9	4,197	Buffer Pool Aware Query Optimization	2005	CIDR
10	8,818	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR