Goldstar Logo
Your Source for Actian Zen and PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
 Version Quick-Reference Chart
+ Actian Zen v16
+ Actian Zen v15
+ Actian Zen v14
+ Actian Zen/PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve 12
+ Btrieve 6.15
+ Actian Vector

+ Protecting Your Data

+ Goldstar Services

+ Goldstar Tools

+ Developer Resources

+ Other Solutions

Using AMS? Status 7224 Fix My PSQL License Report Engine Crash Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

  Utilities Quick Links
Complete Tools List
BtrvInterceptor
DXUtil Page
GSSync Page
KeyCheck Page
LogSplitter Page
PSConfig Page
SQLExec Page
SQLInterceptor
Data File Recovery Toolkit
ViewUNF Page

Goldstar Software Utilities: SQLInterceptor

SQL Query Capture Tool for Actian PSQL and Zen Databases
License Type
Price (USD)
Links
Single User
$350
Buy Now
Site License
$1000
Buy Now
30-Day Trial
Free
Try Now

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 or Actian Zen database 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! Running from the server, you can see all requests from all users, which is useful if you want to know what queries are adding load to the server at any given time. From the workstation, you can use this to troubleshoot individual applications and see why things are taking longer than you expect them to take.

Only need to monitor successful and failed SQL logins? Check out our LoginMonitor tool instead.

The current release of SQLInterceptor (v1.55) supports native IPv4 and IPv6 networks, IPv6 packets coming through a 6to4 gateway, and Cisco 803.1Q tagging. We will add new protocols as trace data samples become available.

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/. Alternatively, you can use the Npcap library, instead, which can be found at https://nmap.org/npcap/.

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!

  Copyright © 1997-2024, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 1945 Maplewood Ln | Munster IN 46321 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us