Abstract: Systems, methods, and machine-readable media may place workloads of source systems in a migration of data and applications from the source systems to target systems. Data relating to a first number of source nodes and a second number of target nodes may be received and analyzed. A migration plan that specifies placement of workloads from source systems into target systems may be created. The placement may include packing a pluggable environment or a clustered environment. The packing the pluggable environment or the clustered environment may include: when the second number of target nodes is greater than the first number of source nodes, placing workload from the source nodes to the target nodes; and, when the second number of target nodes is less than the first number of source nodes, the workload from the source nodes is not placed to the target nodes.

Abstract: A method of modeling a prospective database migration between database systems may include collecting performance data associated with a plurality databases in a first database system. The method may also include receiving a selection of a set of databases in the plurality of databases to migrate to a second database system. The method may additionally include computing, using at least some of the performance data, combined performance data that estimates how the set of databases will perform on the second database system. The method may further include providing one or more indications as to whether the set of databases should be migrated to the second database system. In some embodiments, the one or more indications may be based on the combined performance data.

Abstract: Systems, methods, and machine-readable media are provided for database diagnostics. A specification of a target database system may be processed. A diagnostic tool, corresponding to a plug-in for transmission to the target database system, may be created. A script may be selected to conditionally execute on the target database system when detected values of a monitored parameter satisfy conditional criteria. A plug-in structure that encapsulates modules of the plug-in may be defined. The diagnostic tool may be transmitted via a network to the target database system to cause the diagnostic tool to be executed on the target database system. The execution of the diagnostic tool may include executing a first iteration of the plug-in based on a first threshold specified by conditional criteria, and executing a subsequent iteration of the plug-in based on a subsequent threshold specified by the conditional criteria after the conditional criteria has been adjusted.

Abstract: Embodiments of the invention provide systems and methods for providing services related to managing computer systems. More specifically, embodiments of the present invention provide for providing performance tuning and benchmarking services to remote computer systems. Generally speaking, the service can provide functions to help customers maintain a consistent performance of their databases with minimal downtime by pro-actively addressing issues or bottlenecks with periodic assessments, monitoring of performance metrics that are causing stress throughout the term of the service, reporting violations of agreed upon thresholds for performance, and reactively helping customers address performance issues that arise with reactive tuning.

Abstract: Systems, methods, and machine-readable media are provided for database diagnostics. A specification of a target database system may be processed. A diagnostic tool, corresponding to a plug-in for transmission to the target database system, may be created. A script may be selected to conditionally execute on the target database system when detected values of a monitored parameter satisfy conditional criteria. A plug-in structure that encapsulates modules of the plug-in may be defined. The diagnostic tool may be transmitted via a network to the target database system to cause the diagnostic tool to be executed on the target database system. The execution of the diagnostic tool may include executing a first iteration of the plug-in based on a first threshold specified by conditional criteria, and executing a subsequent iteration of the plug-in based on a subsequent threshold specified by the conditional criteria after the conditional criteria has been adjusted.

Abstract: A database diagnostics system with an interface system that may be used to define, monitor, and deploy database diagnostics tools is presented. The interface system presents a user with a user interface for defining the parameters, behaviors, and schedules of database diagnostic tools. The diagnostic tools execute on a target database recording database parameters and state information. The interface system may present the user with a graphical user interface for assembling diagnostic tools at least partially from a predefined set of reusable modules and scripts.

Abstract: Analysis tools summarize and provide statistics from snapshot files. The analysis tools may provide a temporal view of the changes of the data values across two or more periods of time from one or more snapshot files to show trends in performance of the system. The analysis tools may include meta-data definitions for different sources of the snapshot information.

Abstract: A database diagnostics system with an interface system that may be used to define, monitor, and deploy database diagnostics tools is presented. The interface system presents a user with a user interface for defining the parameters, behaviors, and schedules of database diagnostic tools. The diagnostic tools execute on a target database recording database parameters and state information. The interface system may present the user with a graphical user interface for assembling diagnostic tools at least partially from a predefined set of reusable modules and scripts.

Abstract: A method of modeling a prospective database migration between database systems may include collecting performance data associated with a plurality databases in a first database system. The method may also include receiving a selection of a set of databases in the plurality of databases to migrate to a second database system. The method may additionally include computing, using at least some of the performance data, combined performance data that estimates how the set of databases will perform on the second database system. The method may further include providing one or more indications as to whether the set of databases should be migrated to the second database system. In some embodiments, the one or more indications may be based on the combined performance data.

Abstract: Embodiments of the invention provide systems and methods for providing services related to managing computer systems. More specifically, embodiments of the present invention provide for providing performance tuning and benchmarking services to remote computer systems.

Abstract: Analysis tools summarize and provide statistics from snapshot files. The analysis tools may provide a temporal view of the changes of the data values across two or more periods of time from one or more snapshot files to show trends in performance of the system. The analysis tools may include meta-data definitions for different sources of the snapshot information.