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)
This is a small and simple application that runs as a Windows service to record metrics several times per second. Metrics can be very different. For example, memory usage by a process or ping to a host. The application does not require a DBMS. The data is stored in an open binary format. Data viewing is possible in the form of graphs of the history of changes and in tables of current values. The configuration setting is done without editing the config files - everything is available directly...
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
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.
VisualMon is a concise dashboard for Java web applications, it shows statistics gathered by JAMon, reduced to the data relevant to the concrete web application and with a visually pleasant appearance.
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.
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.
At an early stage of development. Application/middleware usage monitoring/reporting. Focus on business transactions/use cases to help communicate with users. Small footprint, easy to use GUI and a level of statistical analysis to summarise the data.
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.
An implementation of the Open Group's Application Response Measurement (ARM) Version 4 standard. The ARM standard describes a means of breaking an application down into it's constituent transactions, and measuring response time across multiple tiers.
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.
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.
jMonit is a thin, performant, easy to use monitoring toolkit you can add to your app to monitor it's use on production server, including performances, load and scalability. jMonit tracks execution time and threads activity but can also gather any numeri
An adaptable, platform-agnostic application incident reporting infrastructure ranging from logging libs and webservice-based reporting to a J2EE logging server to a pluggable connection to issuemanagers.
simpleWSMonitor will keep track of some values that nearly determine the availability of your webservers. It may help you find some bottlenecks from the server to your visitor and it's very lightweight, it doesn't even need a cron to work.
System monitoring utility, written in plain C. Allows application execution and performance monitoring, saving results into XML files. Monitors CPU, memory, network and disk usage on a per-application or per-system basis.
Process Monitor uses web interface to view system active process and its resource usage. Support multiple host process monitoring. This to allow developer view their active process and Administrator keep tab on system performances.
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