DIADS: A Problem Diagnosis Tool for Databases and Storage Area Networks

Date Added: Aug 2009
Format: PDF

Many enterprise environments have databases running on network-attached storage infrastructure (referred to as Storage Area Networks or SANs). Both the database and the SAN are complex subsystems that are managed by separate teams of administrators. As often as not, database administrators have limited understanding of SAN configuration and behavior, and limited visibility into the SAN's run-time performance; and vice versa for the SAN administrators. Diagnosing the cause of performance problems is a challenging exercise in these environments. The authors propose to remedy the situation through a novel tool, called Diads, for database and SAN problem diagnosis.