How Can I Tell How Many Users Are Using PSQL?

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:


MAD






    • Related Articles

    • EL850US: Btrieve Error 094 on USERS SY Users Lic. File

      Release Date: 02/18/2019 Q - I just implemented Elliott on a Windows 2019 server, when I started up Elliott for the first time, I received the following message: EL850US: Btrieve Error 094 on USERS SY Users Lic. File 94: The application encountered a ...
    • Configure PSQL Server Memory Usage

      Version: Any Release Date: 12/17/2021 Q - Can you tell us why PSQL process is taking up so much memory? Is there anything we can do? See sample screen below: A - PSQL server by default can take up about 60ish% of the server memory. This is ...
    • How to Clear the Message "Unable to Read your Users record (9/068)"

      Released Date: 05/06/2019 Revised Date: 05/19/2025 Version: PSQL 13 or Zen 15 Q: User KSWAYZE received the message "Unable to Read your Users record (9/068)" as shown below and was unable to clear the message or even restart the computer. A: If a ...
    • Does Elliott Count DEFER User Licenses?

      Release Date: 02/08/2024 Version: 7.x - 8.6 Q - I am running out of the PSQL user licenses. I have 20 Elliott user licenses and 20 PSQL user licenses. Is there a way to tell what other applications are using the PSQL engine and how often that ...
    • Elliott 8.6 to Distribute 4.4 PSQL Entity Framework Client

      Release Date: 11/2/2022 Version: 8.6 & Up In Elliott 8.6, we distribute PSQL 4.4 Entity Framework Client for Avalara interface (national sales tax collection). You can expect to see the following DLL file in the Elliott BIN86 folder: ...