Precise Software Solutions, Inc.

Liad Hacmon

Yochai Uliel

Sigal Gelbart

Ehud Eshet

Meyron Ragulsky

Mark Kremer

Chuck Delouis

Dan Zada

Storage management for database access, in which selected data blocks are associated with particular business operations, and in which those data blocks are disposed in response to an assessment of which of those business operations are more important, more urgent, or have a greater need to be reliable. This has the effect that overall transaction performance is improved without significantly increasing infrastructure cost. Noting the relative importance of those particular business transactions and the relative probability that those data blocks will be needed by those particular business transactions, and assuring that data blocks associated with relatively important business transactions are moved to relatively superior storage in advance of requests for access.

Dynamic storage blocks tiering

Apparatus, methods and computer-readable medium for displaying information related to performance of a given database statement which accesses a plurality of multi-partition objects during a time interval. In some embodiments, the method comprises: a) determining, for a given database statement that accesses a plurality of index or table partitions during the time interval, for each accessed partition of a plurality of partitions, a respective aggregate wait time associated with said accessed partition; b) in accordance with the determined wait times for the given database statement, presenting, to a user, a description of performance of the database during the time interval.

Tracking table and index partition usage in a database

Apparatus, methods, and computer code for monitoring a database and for determining estimated aggregate disk-sort wait times for a database statement and/or database table and/or database index and/or database session are described. A description of database performance may be presented to a user in accordance with the determined aggregate disk-sort wait time(s).

Apparatus, method and computer readable medium for identifying and quantifying database disk-sort operations

Apparatus, methods, and computer code for monitoring a database and for detecting execution plan changes in the database. In the event that an execution plan is detected for a given database statement during the course of the monitoring, an alert signal may be generated. Optionally, the generation of the alert signal is further contingent upon a property of the database statement for which an execution plan change has been detected, for example, an execution time. In some embodiments, a detection agent is configured to repetitively attempt to detect an execution plan, for example, in accordance with a specified frequency parameter.

Growing community of inventors

Or Yehuda, Israel

Liad Hacmon