Tony K Leung

US Patent:

20130185282, Jul 18, 2013

Filed:

Mar 6, 2013

Appl. No.:

13/787189

Inventors:

International Business Machines Corporation - Armonk NY, US
Zeus Orion Courtois - San Jose CA, US
Anshul Dawra - San Jose CA, US
Tom William Jacopi - San Jose CA, US
Tony Kai-chi Leung - San Jose CA, US
Sonali Surange - San Rafael CA, US

Assignee:

INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY

International Classification:

G06F 17/30

US Classification:

707714, 707718

Abstract:

Provided are techniques for collecting client information for client applications running on a client computer, wherein the client information includes a client application identifier for each client application that issues queries to a database along with text of each of the queries that the client application issues; collecting database monitoring information that includes text of each query issued against the database and performance information for each query; combining the client information and the database monitoring information based on the text of the queries to obtain combined information that provides the client application identifier and the performance information for each of the queries; and identifying a problem query and at least one client application that has issued the problem query using the combined information.