Best Database Performance Tuning Tools

Jet Profiler for MySQL 4 is a real-time query performance and diagnostics tool for the MySQL database server. Jet Profiler focuses on queries, tables and users. This gives you the information you need in order to quickly fix performance problems in your code, such as most frequent queries, most used tables or the busiest users. Data is collected, analyzed and displayed in real-time in diagrams, pie charts and tables. The graphical layout allows you to easily drill down and navigate your way through the vital data. Most of the profiling work is done in the Jet Profiler application, not in the database server. Therefore, the performance hit is normally negligible, around 1%. It supports all MySQL versions. No database server changes are necessary. No agents or separate services are needed. Jet Profiler is a desktop application which runs on your computer. You start it, connect to a server, hit the record button and you can review the results in minutes.

SQL Index Manager lets you quickly and easily find out the status of your indexes and discover which databases need maintenance. You can do maintenance through the UI, or generate a T-SQL script to run in SQL Server Management Studio. Detect index fragmentation to get a full report on indexes across your databases, including the severity of fragmentation and the reasons for it. Fix fragmentation by choosing which indexes to fix based on fragmentation severity – SQL Index Manager will perform the operation for you. Reorganize or rebuild by setting which action to take, based on customizable rebuild and reorganization thresholds, and rebuild indexes online with SQL Server Enterprise Edition. Analyze over time by exporting the results of your analysis to track and report on fragmentation. Generate scripts by automatically generating T-SQL scripts to fix fragmentation. Start rebuilding or reorganizing selected indexes with a single click.