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:
- 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.
- 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
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 ...How to Use EL850DB.EXE Utility to Create PSQL Databases
Release Date: 12/4/2018 Modified Date: 06/20/2020 Version: Elliott 8.5 Elliott 8.5 includes an EL850DB.EXE utility to make it easy to create PSQL databases. The new utility EL850DB.EXE is included in the Elliott 8.5 release, and you can find it in ...How to Enable PSQL Relational ODBC Security
Release: 04/29/2021 Version: 7.5 & Higher Q - At the moment, our PSQL ODBC access does not require login and everyone has full access to the Elliott database when they connect through ODBC. We are looking at a scenario where most users have read-only ...How to Use Procdump.exe to Create a Memory Dump for PSQL Engine
Released Date: 7/10/2017 If your PSQL server crashes from time to time, then it is necessary to get a memory dump of the PSQL engine processor and send that to Actian tech support for further analysis. The following procedure outlines how to do this. ...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 ...