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)
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.)
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.
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.
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.
SLOCCount is an easy-to-use tool that counts Source Lines of Code (SLOC). It auto-determines the language(s) (inc. C, C++, Ada, Assembly, shell, COBOL, C#, Fortran, Haskell, Java, LISP/Scheme, Perl, PHP, Python, Ruby, SQL). It also estimates cost & time.
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.
Beet adds user behavior and performance tracking to a Spring-based Java app. HTTP requests, method calls, and SQL statements are tracked and associated to user and session. includes XML, binary XML, and JDBC loggers. See http://beet.sourceforge.net.
Rapidlogix is an open source application performance management tool optimized for distributed production environments. It allows to increase time-to-market of performance improvements and prevent performance regression
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.
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.
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.