Find out what is happening with your Firebird SQL server. Discover which user, process, or client consumes the most server I/O resources. Be informed with full reports if something atypical happens: Slow statements, stuck transactions and more.
Dec 26, 2011 12:06:28
Windows ME, Windows NT, Windows XP, Windows 2003, Windows Vista
Description: Sinatica Monitor can help you increase your Firebird server's performance in various ways:
1) Eliminating Slow Statements:
Sintica Monitor makes the job of identifying slow SQL statements easy. You just set the Slow Statements Alarm, and from then on Sinatica Monitor generates an Alarm Report for each incident. This report contains the complete SQL statement identification, along with statistics that will help you understand why it is slow.
2) Decreasing Disk I/O Usage:
Using the Greatest I/O Consumers Chart, you watch in real-time who is consuming the largest amounts of resources from the disk subsystem - processes, users and clients. This information allows you to focus on correcting the biggest consumers and obtaining more expressive performance results in less time.
In addition, Sinatica Monitor also tracks every SQL statements' Table Scan Index. When some statement executes a Table Scan and consumes a lot of disk I/O, Sinatica Monitor generates a report that completely identifies the statement along with I/O statistics.
3) Assuring Good Transaction Flow:
Good transaction management is essential for Firebird`s optimal performance.
Sinatica Monitor identifies which transactions are open in real-time. You may also set the Transaction Alarm and be notified if any of those transactions go past a configured threshold.
4) Constant Monitoring:
In Sinatica Monitor, you have and ally monitoring your databases at all times. Don't wait until your customers complain about your Firebird server's performance. Keep monitoring actively and be alerted at the first signs of difficulty.
ScimoreDB Distributed 4.0 Royalty free fully featured SQL database with nearly 1 million installations worldwide. Fast performance. Scales from small embedded to clustered ScimoreDB database for high load
JDbMonitor 1.00 JDbMonitor is a tool to monitor & analyze database performance for any Java application without code changes. It provides a GUI client that allows local/remote monitoring of SQL