Share this page

# PERF_SERVER_SQLS

This table stores the data collected by the Server SQL monitor.

You can examine the data in this table as it relates to the user actions that are performed (stored in the PERF_CLIENT_OPERATIONS table) and the resulting requests that are generated (stored in the PERF_CLIENT_REQUESTS table).

The table contains one record for each SQL statement run on the server. The column prefix for the table is `PSS`. For example, `PSS_SQL_ID.`

COLUMN NAME | DESCRIPTION
--- | ---
SQL_ID | The SQL unique GUID.
SERVER_MACHINE_NAME | The ALM server that ran this SQL statement.
THREAD_ID | The ID of the thread in the context of which the SQL statement was run.
THREAD_CATEGORY | The thread category.
THREAD_TYPE | The thread type.
PROJECT | The domain and project name, in the format `<domain name>/<project name>`.
USER_NAME | The user name.
SQL_TYPE | The type of SQL statement, for example: `executeQuery' and `executeUpdate'.
RECORD_COUNT | Number of records added, deleted or etched by this SQL statement.
START_TIME | The SQL statement start time as a date time data type.
START_TIME_MS | The SQL statement start time as the number of milliseconds since 01/01/1970.
TOTAL_TIME | The total time, in milliseconds, that it took for the server to execute the SQL statement.
SQL_STRING | The actual SQL string.

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 15.5-15.5.1 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: