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)
logview4net is a log viewer/log monitor for data created by various sources. It can listen to UDP, tail a file, tail a SQL table, monitor the eventlog and watch RSS and Atom feeds. It requires the Microsoft .NET Framework 2.0
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.)
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.
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.
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.
Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.
Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.
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
Tool for monitoring of OCI client applications [f.e.: TOAD/TOra, or any OCI-based fat client] interaction with Oracle Database. Monitors SQL statements and values passed/fetched between client application and RDBMS. Consists of simple and nice GUI [C#] and events handler [C++] with quite a lot of OCI hacking. Interface between handlers and tool's GUI is through tailing of XML "pipeline" files in $HOME/.ocimonitor directory. Tool is quite similar to Quest SQLMonitor, which is unable to trace values.
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.
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