To find information about a session, for example, CPU or I/O data for a specific session, try one of the following tools.
| Tool | Description |
|---|---|
| PM/APIs | If you write your own application, use the MONITOR SESSION request or the MonitorSession function to collect current status and activity information for sessions that are logged on to Vantage. PM/APIs allow you to immediately access session information, but you must have proper privileges to submit the requests or use the functions. |
| DBC.SessionInfo view | Use this view to see the client interface that established the session, the logon date and time, and current role among other information. There is one row for each time a user is logged on. |
| DBQL information | You must have first already enabled logging by submitting the BEGIN QUERY LOGGING statement for the users/accounts/applications you want to monitor. |