Abstract: A system for monitoring, controlling and optimizing power usage and cooling utilization within a data center infrastructure. The system may make use of a subsystem which is adapted to obtain real time information on both facility devices and information technology (IT) devices. The subsystem may be used to evaluate the real time information to provide an alert and diagnostic information with respect to at least one of the facility devices or at least one of the IT devices. The subsystem may also make use of a mechanism that provides real time control over at least one of the facility devices or at least one of the IT devices to optimize at least one of cooling utilization, power usage or performance of at least one of the facility devices or at least one of the IT devices.

Abstract: Embodiments of the present invention provide a system and method for service management in a distributed database environment. In general, embodiments of the present invention provide a service manager that connects to or is part of a database appliance that collects database performance data in the distributed database system. The database appliance accesses traffic between database clients and database servers and collects a variety of database performance statistics without having to rely on agents at the database clients or database servers. The service manager can access the performance data from the database appliance (locally or over communications link) and archive the performance data. Additionally, the service manager can compare items of the performance data (e.g., specific performance statistics) to user defined thresholds. If a threshold is met, the service manager can notify a user by, for example, sending an email.

Abstract: Embodiments of the present invention provide systems and methods for applying policies at a database appliance. The database appliance, according to one embodiment, can receive a database request and determine a set of information related to the request. The information related to the request can include information, such as metadata, defined at information systems external to the database server to which the request is directed. Policies can be applied in terms of the information related to the request. By leveraging information systems, embodiments of the present invention allow policies to be applied to account for the networked environment.

Abstract: Embodiments provide systems and methods for verifying paths to databases. A method for identifying paths to a database may comprise opening a database in a set of databases utilizing a known path to the database, creating an object in the database and checking for the object utilizing one or more paths in a set of paths to databases, wherein paths in the set of paths corresponding to a database containing the alias are paths to the database. By repeating the above process for multiple databases, paths to multiple databases may be verified.

Abstract: A tree map visualization for database performance data comprises an observable object of a database system, a hierarchical structure of the database system, the hierarchical structure comprising a database relationship involving the observable object, a first performance metric associated with the observable object, and a second performance metric associated with the observable object, wherein the first performance metric associated with the observable object is represented by the size of a rectangle that represents the observable object and the second performance metric associated with the observable object is represented by a color of the rectangle that represents the observable object.