7 Generic TSQL Scripts to Troubleshoot SQL Performance Problems
"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)
AnalysesOracle Performance Doctor is a tool which helps you to understand the behavior of your application on Oracle database level.
The tool does:
1. Extract execution plan for all SQLs executed by specified db user and print it to file on server side.
2. For all executed SQL statements the tool will provide more performance version of sql text by using built-in module dbms_sqltune.
Investigo is a toolkit for DirectX9 performance analysis and debugging.
For any DirectX9 application: view live performance graphs via the embedded HTTP server and capture performance metrics for offline analysis.
Investigo is released under an MIT style licence.
The first binary release is now up.
An article on Investigo can be found on Code Project:
http://www.codeproject.com/Articles/448756/Introducing-Investigo-Using-a-Proxy-DLL-and-embedd
If you want to work on Investigo and help move it forward, please join me on SourceForge!
...
Deploy in 115+ regions with the modern database for every enterprise.
MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
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.
Lack of Progress Bar (Lopb) is an Eclipse plugin that tracks how long developers wait for file check-ins/outs, code compilation, publishing apps to a web server, and other IDE background jobs to complete. Read more at http://lopb.org
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.
BencHTTP is a utility to test the performance of HTTP servers under load. It is highly configurable via simple script files and allows extensive customisation of HTTP requests. The current serverperformance is continuously displayed during the test.
Performance profiler for Amiga AACE/Tao Intent software. Works for source in both C and VP. Includes filters to convert data into cvs spreadsheets. (Compiles under Linux as well, but no Linux build system is included)
jCello is a Java instrumentation framework which can be utilized to understand application behavior and performance. This package includes an agent (client) and collection/reporting server.