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 ...New Elliott PSQL Server Processor and RAM Suggestions
Q - We are going to upgrade to a new Windows Server 2012 R2 for PSQL 11 64-bit by the end of the year. Does PSQL take advantage of additional Intel processor cores and/or give some advice or algorithms on the amount of RAM that should be installed 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 ...IPV6 May Cause Problem for PSQL 11 Relational Query
Release Date: 01/20/19 IPV6 (Internet Protocol Version 6) is designed to eventually replace IPV4. IPV4 has an IP address like 192.168.1.1. Each segment can have a value from 0 - 255, so the theoretical maximum number of IPV4 addresses is a little ...