Why Did My Query Slow Down

11 years 1 months ago
Why Did My Query Slow Down
Enterprise environments have isolated teams responsible separately for database management and the management of underlying networkattached server-storage infrastructure (referred to as Storage Area Networks or SANs). Our vision is to develop an innovative management framework to simplify administrative tasks that require an understanding of both database and SAN details. As a concrete instance, this paper describes problem diagnosis of a database query slowdown. To address the diagnosis challenges including noisy monitoring data, we have implemented DIADS, which uses existing monitoring tools to generate Annotated Plan Graphs (APGs). Using an innovative workflow that combines domain-specific knowledge with machine-learning, DIADS was successfully applied on a real-world testbed to pin-point complex combination of events across both the database and SAN.
Nedyalko Borisov, Sandeep Uttamchandani, Ramani Ro
Added 08 Nov 2010
Updated 08 Nov 2010
Type Conference
Year 2009
Where CIDR
Authors Nedyalko Borisov, Sandeep Uttamchandani, Ramani Routray, Aameek Singh
Comments (0)