Abstract: A database service may distribute resources across different geographic locations or other infrastructures to increase availability of the resources and may provide multiple locations to access resources and isolate failure of resources to a respective location or infrastructure. The processing resources in differing fault tolerance zones may be able to continue operating in the event of an outage impacting an entire fault tolerance zone. The database service may generate a supporting processing cluster in the differing fault tolerance zone that handles at least a portion of the access requests of an initial processing cluster. The database service may provision the supporting processing cluster in a separate fault tolerance zone that has a similar capacity and may provision and maintain the cluster in order to preclude the potential of not having sufficient capacity to recover upon failure of a single fault tolerance zone.

Abstract: Granular performance analysis may be performed for database queries. Database query performance may be monitored. For some database queries, performance of portions of the database query may be measure. The measure performance of the portions may be compared with performance goals that correspond to the portions of the database query. Portions that do not meet or exceed the corresponding performance goals may be identified so that an indication of the identified portions may be provided.