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)
Kieker is a framework for continuous monitoring and dynamic analysis of distributed software systems. Being designed for continuous operation, it induces only a low overhead. The TraceAnalysis tool allows to analyze and visualize trace information.
cpuplot
Command Line Profiler of CPU Usage and Load Average.
Synopsis:
BASH script that shows the history of CPU usage, and what procces uses the most CPU at a given time.
Bar graphs represent the percentage of Total CPU Usage, and the percentage of Total 1 Minute Load Average.
Default wait interval between system readings is 5secs. But a different one can be set in the command line with the "-i" argument. Default output is formatted for the standard console width of 80...
Simple and powerful tool for benchmarking your code's efficiency
Centurion is a very simple and powerful tool for benchmarking your code's efficiency.
How to use it:
var my_centurion = new centurion();
Centurion API namespaces:
.benchmark - Do a benchmark
.status - Check status of benchamark.
To see the full API under the namespaces do:
"console.log(my_centurion);"
Enjoy!
Stop waiting on engineering. Build production-ready internal tools with AI—on your company data, in your cloud.
Retool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
A collection of library code and tools for application execution profiling and performancetesting. You can create stopwatches to time select portions of your code. You can measure differences (often to sub-millisecond accuracy) between clocks on different machines. You can log application events in a .csv format for subsequent analysis. You can also generate CPU loading logs in a .csv format.
Stand alone Java application used simulate a memory leak in order to generate profile signatures. The application has the ability to generate system (CPU) load in order to observe profile signature changes.
Framework for profiling & early performancetesting of J2SE, thread based applications. Integrates into the Maven build-cycle. Closely integrates with YourKit profiler to produce automatic CPU profiling of you application.
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.
AppSignal starts at $23/month with all features included. No overages, no hidden fees. 30-day free trial.
Tired of monitoring tools that punish you for scaling? AppSignal offers transparent, predictable pricing with every feature unlocked on every plan. Track errors, monitor performance, detect anomalies, and manage logs across Ruby, Python, Node.js, and more. Trusted by developers since 2012 with free dev-to-dev support. No credit card required to start your 30-day trial.
ViennaProfiler allows to compare execution times of full programs or parts of a program. Execution times are stored in a MySQL database and conveniently analyzed via a web-interface. A C++ client API is provided, other languages can also be used.
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
COMPAS J2EE is a non-intrusive performance instrumentation and monitoring toolkit for J2EE.
It uses adaptive monitoring to automatically adjust the target coverage. COMPAS is completely portable across J2EE application servers and OSs.
Free Java monitoring library to easily instrument apps to measure performance detail over time with minimal overhead. Has dashboard, SVG graphs. Extends Jamon and its statistical data, same usage. http://www.e-peas.com/opensla/. JMX, SNMP planned.