Open Source Profiling Software

Cinemagoer is a Python package useful to retrieve and manage the data of the IMDb movie database about movies, people, characters and companies. Platform-independent, it can retrieve data from both the IMDb's web server and a local copy of the whole db.

This software provides PL/SQL packages for defining and measuring business tasks utilizing Oracle's extended SQL tracing mechanism.

Elvyx is a tool designed to monitor and profile the jdbc activity on java projects. This jdbc profiler has a server with a built-in db and a client to improve the experience.

JDBC Tools is a proxy driver framework for monitoring Java database access. It has pre-built JDBC logger and SQL query planning modules, but can be extended through a simple API to perform other monitoring operations.

LightProfiler – application for performance analysis of the Oracle databases. It generates detailed resource profile for extended SQL trace files (10046 event), containing information about consuming of response time (by events, by cursors, etc.), data files usage, error analysis (SQL, PL/SQL) and much more. Also it contain tools for additional processing of trace files (extract session data, splitting files) and for management of database's sessions (disconnecting, tracing, monitor parameters, blocking locks, events and etc.)

Maatkit (formerly MySQL Toolkit) contains essential command-line tools for MySQL. It is now hosted at http://code.google.com/p/maatkit/ instead of Sourceforge. Please do not use the forums here; use http://code.google.com/p/maatkit/ instead.

Mad for DB - The Migration Advisor for DataBases - analyzes the differences between two database schemas, automatically finds out which changes require individual migration effort and advises migrators which concrete datasets need fixing.

"It's not a tool, which fixes a problem, but the fool using it!" (Jörg Stryk) The M7 bunch of scripts should help the EXPERIENCED Troubleshooter to quickly identify bottlenecks and to develop/implement appropriate solutions. "With great power comes great responsibility" (Uncle Ben)

MySQL log analyzer and profiler. Extracts the most popular queries grouping them by their normalized form and shows the statistics for each group. Helps developers to recognize most frequently run queries to be able to optimize overall db performance.

A public implementation of the OO7 benchmark. Currently we are focusing on Java, but other languages may be supported too.

Java Oracle Resource Profiler

Orate is a source-level tracing facility for Oracle PL/SQL. Programmers insert calls to Orate in the code and Orate captures and writes run time information to a table. These data are suitable for debugging, testing and profiling the application.

A fully automated database benchmark suite that prints tabular and graphic results for multiple tested disciplines, given JDBC database connections. Some free open source database engines are included.

An SQL profiler and eclipse plug-in for Rational Application Developer. A view that displays SQL data from RAD application server test environment.

Tiny SQL Profiler is a free replacement tool for Microsoft SQL Profiler, it allows you to view queries made against SQL Server 2005 database in real time using sophisticated arsenal of filters, making it easier to debug and diagnose database applications

Simple monitoring utility to help optimizing a (MySQL) database server. Run the utility for a time to record queries on the database. Generate reports while the utility is running or afterwards. Reports are available as text or excel-sheets.

gen_names populates customer/invoice tables with random (but realistic looking) data. The data has been gathered from various sources including census and local council web sites. It is supposed to be used to road test various DBMS solutions.

insideApps from determyne: Transaction-level performance monitoring for J2EE applications. Correlates and reports on transactions across HTTP server, J2EE container, and database layers. Pinpoints the source of performance issues in real time.

This tool will analyze your MySQL binary log (binlog) files. (Requires mysqlbinlog). Query speed, distribution, and size are reported.