Chat now with support
Chat with Support

Foglight for PeopleSoft 5.6.11 - User and Reference Guide

Using Foglight for PeopleSoft
Exploring the PeopleSoft Dashboards Foglight for PeopleSoft Agents PS_AppMonitor Agent PS_AppServer Agent PS_DB2SQL Agent PS_MSSQL Agent PS_OracleSQL Agent PS_PPM Agent PS_SchedMonitor Agent PS_SchedServer Agent PS_Scheduler Agent Manual Agent Naming Deployment Scenario Procedures
Foglight for PeopleSoft Reference
Views
PS_AppServer Views PS_DB2SQL Views PS_MSSQL Views PS_OracleSQL Views PS_PPM Views PS_SchedServer Views PS_Scheduler Views
Data

PS_MSSQL_PID_Detail Table View

Purpose
The PS_MSSQL_PID_Detail (MS SQL Process ID Detail) table view presents details about the different PeopleSoft application users who are in the database at the time of data collection. The PS_MSSQL_PID_Detail table view contains information about the users, the SQL or the stored procedures that they are running, along with PeopleSoft application server domain information and SQL metrics. The values are derived from the PS_MSSQL UserData Data Table.
 
Table 18. Description of the PS_MSSQL_PID_Detail Table View
Data displayed
•
PS Machine Name — The name of the computer that the PeopleSoft application user logged in from.
•
PS Process Name — The name of either the application server or the process scheduler process.
NOTE: The PSProcessName value depends on the Select server for the agent property (SQL Server SQL Criteria). If the PS_MSSQL Agent is installed on the database server, this field only shows PeopleSoft as values. If the PS_MSSQL Agent is installed on the box where PeopleSoft application server domain(s) are configured, then the process names (PSAPPSRV, PSSAMSRV, and so on) belonging to only those domains on the box are displayed in the ProcessName column. Processes belonging to PeopleSoft application server domains not on the same box are displayed as PeopleSoft.
•
SQL Statement — The SQL statement syntax or stored procedure name being executed by the PeopleSoft application user.
 
•
SQL Status — The status of the SQL Server 2000 Session ID. The status can have one of the following values:
 
•
Sleeping
•
Background
•
Runable
•
Running
•
PS Application User — The PeopleSoft operator ID executing the SQL statement.
•
PS Domain Name — The online Application Server Domain Name associated with the SQL statement. For Process Scheduler and two-tier processes, this column is blank.
•
Percent CPU — The CPU percentage for the PeopleSoft process. This percentage is relative to the total PeopleSoft CPU.
•
Percent IO — The I/O percentage for the PeopleSoft process. This percentage is relative to the total PeopleSoft I/O.
•
Buffer Gets — The number of buffer reads by the SQL statement.
•
Disk Reads — The number of disk reads by the SQL statement.
•
Total IO — Shows I/O consumed for this PeopleSoft Process.
•
Total CPU — Shows the CPU consumed for this PeopleSoft Process.
•
Rows Processed — The number of rows returned by the SQL statement.
Where to go next
n/a

PS_OracleSQL Views

The PS_OracleSQL Agent includes the following views:
•
PS_Ora_PID_Overview Graph View
•
PS_Ora_PID_Detail Table View

PS_Ora_PID_Overview Graph View

Purpose
The PS_Ora_PID_Overview (Oracle Process ID Overview) graph displays the HitRatio for the various sessions in the Oracle database corresponding to the shadow PeopleSoft application server process PIDs. A low hit ratio indicates an intensive I/O SQL statement being executed. The values are derived from the  UserData table.
 
Table 19. Description of the PS_Ora_PID_Overview Graph View
Data displayed
•
HitRatio% — The SQL statement hit ratio reported as a percentage.
Where to go next
Drill down on HitRatio (%) bar. For more information, see PS_Ora_PID_Detail Table View. This displays that particular Oracle session.

PS_Ora_PID_Detail Table View

Purpose
The PS_Ora_PID_Detail (Oracle Process ID Detail) table view presents details about the different PeopleSoft application users who are in the database at the time of data collection. The PS_Ora_PID_Detail table view contains information about the users and the SQL that they are running, along with PeopleSoft application server domain information and SQL metrics. The values are derived from the PS_OracleSQL UserData Data Table.
 
Table 20. Description of the PS_Ora_PID_Detail Table View
Data dislayed
•
PS Application User — The PeopleSoft operator ID who is executing the SQL statement.
•
PS Process PID — The PID corresponding to the PSProcessName.
•
PS Domain Name — The online Application Server Domain Name associated with the SQL statement. For Process Scheduler and two-tier processes, this column is blank.
•
PS Process Name — The name of either the application server or the process scheduler process.
•
PS Machine Name — The name of the computer that the PeopleSoft application user logs in from.
•
SQL Statement — The SQL statement syntax being executed by the user.
•
SQL Status — The status of the DB2 Session ID. The status can be one of the following values:
•
Connect pending
•
Connect completed
•
UOW executing
•
UOW waiting
•
Lock wait
•
Commit active
•
Rollback active
•
Recompiling a plan
•
Compiling a SQL statement
•
Request interrupted
•
Disconnect pending
•
Prepared transaction
•
Heuristically committed
•
Heuristically rolled back
•
Transaction ended
•
Creating Database
•
Restarting a Database
•
Restoring a Database
•
Performing a Backup
•
Performing a fast load
•
Performing a fast unload
•
Wait to disable table space
•
Quiescing a tables pace
•
Waiting for remote node
•
Pending results from remote request
•
Hit Ratio — The SQL statement hit ratio reported as a percentage.
•
Buffer Gets — Number of buffer reads by the SQL statement.
•
Disk Reads — Number of disk reads by the SQL statement.
•
Number Executions — Number of times a SQL statement executed.
•
Rows Processed — Number of rows returned by the SQL statement.
•
PS Oracle SID — Name of the Peoplesoft Oracle SID.
•
SQL Hash Key — SQL hash value of the SQL statement.
Where to go next
n/a
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating