Share on Facebook Tweet on Twitter Share on LinkedIn Share by email
Online autoadmin: (physical design tuning)

Nicolas Bruno and Surajit Chaudhuri

Abstract

Existing solutions for the automated physical design problem require explicit invocations of tuning tools and critically depend on DBAs gathering representative workloads manually. In this demonstration, we show an alternative approach to the physical design problem. Specifically, we demonstrate a novel monitoring/tuning DBMS component that we prototyped in Microsoft SQL Server 2005 as a server-side extension. This component is always-on and continuously modifies the current physical design reacting to varying workload or data characteristics. Our solution imposes low overhead and takes into account storage constraints, update statements, and the cost to create physical structures.

Details

Publication typeInproceedings
Published inSIGMOD
PublisherAssociation for Computing Machinery, Inc.
> Publications > Online autoadmin: (physical design tuning)