ODBC Stats
ODBC Stats is an ODBC administrators tool and performs realtime ODBC connection monitoring.
Contents
Requirements
ODBC Stats has the following requirements:
- GNU C++ compiler
- QT version 4.1+
- unixODBC version 2.2.11+
- CMake
Although ODBC Stats has only been tested with unixODBC, it will likely work with other ODBC libraries, such as those on Windows systems.
Installation
To build ODBC Stats, first extract the archive and change into the source directory. The build process follows the standard CMake build process:
- mkdir build
- cd build
- cmake ../
- make
- sudo make install
Summary
The ODBC Statistics program monitors the ODBC activity on a host in real-time.
ODBC Statistics Summary InformationThe ODBC Statistics summary information tab (shown in the screenshot at the top of this page) provides a quick overview of ODBC activity. The four bars represent the following information:
- Environments Displays the current total number of ODBC environments. Each ODBC application will create an ODBC environment prior to making a connection. Usually there will be one environment for each ODBC application.
- Connections The current total number of ODBC connections. An ODBC application can create more than one ODBC connection
- Statements Represents the total number of current ODBC statements. An ODBC statement is much more than just a simple SQL statement. An ODBC statement includes the query results and any parameters used.
- Descriptors The current total number of ODBC descriptors. An ODBC descriptor holds column and dynamic information.
The refresh interval setting configures the amount of time that passes between statistic updates. The time is represented in tenths of a second.
ODBC Statistics DetailsThe ODBC Statistics details information tab (shown below) provides more detailed information on the current ODBC activity.
The ODBC Statistics details table lists each process that uses ODBC and provides a breakdown of the statistics shown on the summary tab. The details tab shows the following information on the table:
- User Column The user column represents the users who are currently utilising ODBC.
- Program Column The program column represents that application that they are using to access ODBC.
- PID Column The third column shows the process ID of the application accessing ODBC.
All the other columns represent the data shown in the totals on the summary page. This information is broken down for each process.
Downloads
| Version | Description | MD5 |
|---|---|---|
| 0.3 | Source code | c52ea053051deb97cddd98e958472701 |
The current development source for ODBC Stats can be found in the KDE subversion repository under trunk/playground/sysadmin/odbcstats/.
Changes
Version: 0.3
Author : Ian Ventura-Whiting (Fizz)
Date : 03/10/2006
Changes: This version is Qt4-based. Only patches
will be applied to the latest Qt3-based
release (0.2.x). The next version will be
KDE 4-based and released as part of a
SQL tools package, which will include
Data Sources.
Feature : Qt4-based.
Feature : CMake or QMake build.
Improved: Documentation.
Version: 0.2
Author : Fizz
Date : 06/12/2005
Changes: Feature : Added username and program
details to the ODBC details
page.
Improved: Vastly improved the "Whats this"
help.
Improved: Improved the "Tool Tips".
Improved: Added unixodbc contributors to
about dialog.
Improved: Increased the minimal refresh setting
to 1/2 a second from 2 tenths.
Improved: The details table only has rows for
valid connections.
Improved: Increased total number of possible
entries to 64 from 10.
Fixed: Added missing LICENSE file.
Version: 0.1
Author : Fizz
Date : 27/11/2005
Changes: Feature : Added ODBC Summary Statistics.
Feature : Added ODBC Detailed Statistics.
Improved: Added "About ODBC Stats".
Improved: Added "Tool Tips".
Improved: Added "Whats this".
Improved: Added Icons, thanks to KDE
License
ODBC Stats is covered by LGPL version 2. You can get a copy from here.