Goldstar Software Utilities: SQLInterceptor
SQL Query Capture Tool for Pervasive PSQL Databases
One of the biggest problems in any environment is visibility into SQL queries that are hitting your server. A sudden flurry of complicated queries coming in from a single workstation and your server can be brought to its knees -- and you may never know why.
In the past, dealing with long-running SQL queries required you to install a network analyzer like Wireshark, then dig through the resulting packet data looking for SQL queries. Once you found the query, if you also wanted to know how long it took, you had to then find the corresponding reply packet, then calculate the time difference between the two. Ugh!
This whole process gets a lot easier with Goldstar Software's SQLInterceptor utility. This tool is designed to run on either a workstation or server and watch the network for any requests going to the Pervasive PSQL engine (the SRDE). When it sees a request, it can log the important details, such as packet time, length, request type, and more -- even providing the actual SQL query, too!
The current release of SQLInterceptor (v1.31) only supports IPv4 networks (and IPv6 packets coming through a 6to4 gateway) at this time, and it provides limited logging options (text and CSV only). However, we expect this product to quickly become a platform for additional features, including native IPv6 support, logging to a database file, and more. (Watch this space as new features are added.)
Note: SQLInterceptor uses the open-source library, WinPcap, which must be installed before SQLInterceptor will work. You can download the latest version of this library from http://www.winpcap.org/.
SQLInterceptor can be purchased as a single-user license or as a LAN site license, which allows you to run it on any number of workstations in your environment. Order online with the links above or contact us for details!