Abstract: Database change test system that includes an SQL performance analyzer (SPA) to efficiently test execute workload set of queries on a production or test database management system (DBMS) and report to a user the impact of database changes, is provided. Techniques are described that limit the resource consumption of test execution of workload set of queries, especially to enable such test execution on a production DBMS. A method and apparatus for storing in persistent storage query test profile that specifies query test restrictions and execution plan parameters, which indicate how to generate execution plan operators for query execution plans; storing a workload set of queries in persistent storage; establishing a session with a database management systems; retrieving the query test profile; configuring the session according to the test profile; receiving user input requesting to execute the workload set; and executing the queries according to the query test profile, is also provided.

Abstract: A method for obtaining data items from an unresponsive database host. The method includes receiving an indication that the database host is unresponsive, receiving, from a management server via a diagnostic connection, a first request for a first organized data item, and sending a first query, using a first interface, to a memory for the first organized data item. The method further includes receiving, from the management server via a normal connection, a second request for a second organized data item, retrieving, from memory on the database host, a first data item in response to the first query, converting the first data item into the first organized data item, and sending the first organized data item to the management server, wherein the first organized data item is analyzed to determine a source causing the database host to be unresponsive.

Abstract: Database change test system that includes an SQL performance analyzer (SPA) to efficiently test execute workload set of queries on a production or test database management system (DBMS) and report to a user the impact of database changes, is provided. Techniques are described that limit the resource consumption of test execution of workload set of queries, especially to enable such test execution on a production DBMS. A method and apparatus for storing in persistent storage query test profile that specifies query test restrictions and execution plan parameters, which indicate how to generate execution plan operators for query execution plans; storing a workload set of queries in persistent storage; establishing a session with a database management systems; retrieving the query test profile; configuring the session according to the test profile; receiving user input requesting to execute the workload set; and executing the queries according to the query test profile, is also provided.

Abstract: A method for obtaining data items from an unresponsive database host. The method includes receiving an indication that the database host is unresponsive, receiving, from a management server via a diagnostic connection, a first request for a first organized data item, and sending a first query, using a first interface, to a memory for the first organized data item. The method further includes receiving, from the management server via a normal connection, a second request for a second organized data item, retrieving, from memory on the database host, a first data item in response to the first query, converting the first data item into the first organized data item, and sending the first organized data item to the management server, wherein the first organized data item is analyzed to determine a source causing the database host to be unresponsive.