The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 12, 2004
Filed:
Dec. 31, 2002
Serge G. Marokhovsky, Upton, MA (US);
Shuzi Chen, Newton, MA (US);
Sadasiva K Prathab, Hopkinton, MA (US);
Anthony Ward, Pensacola, FL (US);
EMC Corporation, Hopkinton, MA (US);
Abstract
Database performance assessment typically entails logging and capturing utilities which tend to gather large quantities of unwieldy data leading to a cumbersome and indefinite analysis. A system and method for database performance analysis includes periodic sampling of pending database requests, rather than exhaustive monitoring and capturing all database access traffic, to identify areas of contention. A database access queue is periodically sampled, or scanned, to gather a snapshot of pending requests of database transactions. Pending requests are aggregated by an aggregating process which aggregates, the samples with previous samples corresponding to the same transaction. Correlating the aggregated samples identifies transactions which have been pending the longest and identifies tables and segments in the database which have a relatively high number of pending transactions. By periodically sampling, rather than exhaustively logging all requests, CPU intrusiveness is minimized, trivial, benign transactions are eliminated from the output, and the most burdened tables and segments are identified to enable a database administrator to make informed decisions about remedial actions.