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 Agent

The PS_MSSQL Agent provides a breakdown of database user activity and the statistics necessary to identify usage trends for the PeopleSoft database users. The PS_MSSQL Agent also monitors the PeopleSoft-related SQL or stored procedures activity for both online (through the application server) and two-tier applications like the PeopleSoft Process Scheduler. The PS_MSSQL Agent identifies the PeopleSoft application users and links them to the SQL statements or stored procedures they are issuing through the application server process. It also identifies important database metrics for the SQL statements as well as PeopleSoft application server domain metrics.

PS_MSSQL Agent Properties

When an agent connects to the Foglight Management Server, it is provided with sets of properties that it uses to configure its correct running state.
Each agent is provided with a combination of two types of properties: agent properties and shareable properties.
Default versions of these properties are installed with the Foglight for PeopleSoft. However, you can edit the default shareable and agent properties, configure agent properties that apply only to a specific agent instance, and create edited clones of shareable properties that are used by a subset of the agents of a certain type.
For more information about working with agent properties, see the Foglight Administration and Configuration Guide.
 
* 
NOTE: EnableDBMonitoring should be set to one in the PeopleSoft application server domains in order to gather complete information for the PS_MSSQL UserData table.
The PS_MSSQL Agent is shipped with default properties that can be modified to suit your system requirements.
To modify agent properties:
1
Ensure that the navigation panel on the left is open.
To open the navigation panel, click the right-facing arrow on the left .
2
Open the dashboard that lets you navigate to the agent properties by completing one of the following steps:
•
On the navigation panel, under Dashboards, choose Administration > Agents > Agent Properties.
In the Agent Properties dashboard, in the Namespace > Type pane, select Legacy > PS_MSSQL.
In the Agent Properties dashboard, in the Adapter pane, click SPI. In the Types pane that appears, click PS_MSSQL.
or
•
On the navigation panel, under Dashboards, choose Administration > Agents > Agent Status.
In the Agent Status dashboard, select the instance of the PS_MSSQL agent whose properties you want to modify and click Edit Properties.
A list of agent properties appears in the PS_MSSQL pane.
The position of the Properties pane depends on the dashboard you used to access agent properties. If you used the Agent Properties dashboard, the Properties pane appears to the right of the Namespace > Type pane in the display area. If you used the Agent Status dashboard, the Properties pane appears across the display area.

Setting the PS_MSSQL Connection Details

The PS_MSSQL Agent must be configured with specific database information before the agent can connect to the database to collect PeopleSoft user transactions within the database.
Connection Details agent properties allow you specify the environment variable to which the agent uses to connect to the PeopleSoft database. The connection information consists of a DataSource Name (DSN), Database Login ID and Password.
To set the connection details:
1
Go to the Connection Details set of properties.
2
Enter the DataSource name defined in the ODBC connection template in the Datasource Name (DSN) box.
3
Enter the user account login that accesses the PeopleSoft database in the Database Login Name box.
 
* 
NOTE: This user must have select authority to access the following MSSQL SQL Server 2000 system and PeopleSoft tables:
- sysprocesses
- PSLOCK
- PSSTATUS (PeopleTools 8.x)
To retrieve the SQL statement, the user requires the following privileges:
  Execute DBCC TRACEON (3604,3626)
  Execute DBCC INPUTBUFFER (spid)
To retrieve the BufferGets, DiskReads, RowsProcessed, the user requires the following privileges:
  Execute DBCC TRACEON (3604,4032)
  Execute DBCC PSS (0,spid)
The privilege to execute DBCC PSS command is not applicable to SQL Server 2005 because the DBCC PSS command does not work in this version.
For SQL Server 2005, instead of the privilege for executing DBCC PSS commands, the user must have the select authority for the following system views:
- sys.dm_exec_requests
- sys.dm_exec_sql_text

To retrieve PSApplicationUser, PSDatabaseUser, PSDomainName, PSMachineName, PSOSUser, PSPercentCpu, PSPercentIO, PSProcessName, PSProcessPID, PSRawIOCount, PSSessionID, Status, the user requires privileges to perform the following:
- Select from table master..sysprocesses and master..sysdatabases.
4
Enter the password for the database login in the Database Login Password box.
5
Click Save.
When the PeopleSoft Connection Details agent properties are properly configured, the Management Server gathers data from the PeopleSoft agent.
6
Go to the Setting the PS_MSSQL Data Management Parameters section.

Setting the PS_MSSQL Data Management Parameters

Use the Data Management agent properties to set the sample frequency.
To set the data management properties:
1
Go to the Data Management set of properties.
2
Choose the list from the Edit Table Sample Frequencies list that you want to update.
The collection rate, or sample frequency, is the number of seconds between the end of a collection period and the start of the next. The sample frequency can either be controlled at the agent level or set for each table. Table level sampling is the preferred method.
 
* 
IMPORTANT: Use Add or Delete only when directed to by Dell Support.
 
* 
NOTE: A single table is used for this agent.
3
Click Edit.
A secondary property list appears.
4
Add an entry to the list by clicking Add Row.
Fill in the dialog box fields.
 
* 
NOTE: Through a default template (PS_MSSQL_samplefreq_template), a default sample frequency list (PS_MSSQL_samplefreq_list) is available, as described above. This default list has to be selected for use with this version of PS_MSSQL Agent. An earlier default list (PS_MSSQL_SampleFreq) is no longer valid with the current update and should no longer be used.
5
Click Save Changes.
6
Ignore the Purge All Data After text box. This field is not functional.
7
Click Save.
The PS_MSSQL Agent attempts to run on the Foglight Console. If successful, the agent status is listed as running.
 
* 
NOTE: For help configuring the other agent properties, see the Foglight online help.
8
Go to the Setting the PS_MSSQL Server Filter Parameters section.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating