How Can I Tell How Many Users Are Using PSQL?

Release Date: 02/08/2024

Versions: PSQL 13 and Up

If you suspect you are running out of PSQL licenses or just want to know how many users are using PSQL, Actian has a utility that provides that information: Monitor.  PSQL Monitor utility provides open files, sessions, and resource usage information.  It is useful if you need to know more of the internal operations of the PSQL database.

Log into the server where PSQL is installed.  There are two ways you can launch PSQL Monitor:

1. In the Windows programs you will find an Actian PSQL group and under that will be PSQL Monitor.  The utility will prompt for a server to monitor.
2. If you have a shortcut to bring up the PSQL Control Center, you can choose Tools from the menu along the top and then Monitor.

The selection defaults to the server you are on, but you may have to select a different server.  If so, you may need the administrator password to monitor the server.  Another window will appear and you will click the Resource Usage tab.

Here you can see the current number of users, the peak that has been reached since the server has been up, and the maximum number of users allowed according to your license.  You can see who the users are by clicking on the MicroKernel Sessions tab.

The first column contains the user ID that is using PSQL. Some of these may be "SRDE:<anonymous>" or "SRDE:Master."  These sessions are accessing the data through ODBC or directly through the PSQL Control Center.  Since you may access the data through ODBC with Excel, Crystal, or shipping software, you should take these into account when you are calculating the number of PSQL licenses needed.

See also related KB articles:

    https://support.netcellent.com/portal/en/kb/articles/btrieve-error-161-on-password-file-when-starting-up-elliott

    https://support.netcellent.com/portal/en/kb/articles/what-to-do-when-psql-11-license-is-disabled

MAD

• Related Articles

• Slow PSQL Relational Engine Performance

  Release Date: 12/15/2017 Many users encounter situations where a particular relational engine SQL query can sometimes be slow. This can be complicated to diagnose due to a lot of reasons. Sometimes it's because of a SQL SELECT statement that's not ...

• Hardware Recommendations for Your PSQL Database Server

  Release Date: 10/10/2017 This article was written by Bill Bach and is provided at the courtesy of Goldstar Software. Recommendations for hardware for your PSQL database environment One of the most common questions we get is “What kind of hardware ...

• Using the Export Processor to Export Data

  Q: It has been a while since we used the Export Processor to Export Data from Elliott. I remember how to select the category and choose the search data, but I can't remember how to select all the fields that need to be processed for export. Can you ...

• PSQL Download and Installation with Video

  Release Date: 09/12/2023 Version: 7.x & Up Elliott Business Software depends on the PSQL database engine. Our latest version, Elliott 8.6, requires either PSQL 13 or 15. In this article, we are going to show you how to download and install the PSQL ...

• Setup of the PSQL 13 Report Engine

  Release Date: 8/14/2019 Version: PSQL 13 & up Benefits of PSQL 13 Report Engine The most significant feature in PSQL 13 is the report engine feature. Before PSQL 13, the Elliott application, web services and other third party applications that needed ...