Configuring Process Monitoring of the Database 

Use

The monitoring of important database processes is described here as an example of process monitoring (see Monitoring Selected Processes with SAPOSCOL). A simple availability monitoring of the database is possible in this way. Process monitoring requires the operating system collector SAPOSCOL and a NetWeaver management agent.

Procedure

       1.      Change to the working directory of SAPOSCOL; this is \\<host>\saploc\prfclog (Microsoft Windows) or /usr/sap/tmp (UNIX).

       2.      Edit or create the file dev_proc. Ensure that the file starts with $PROC and ends with $. Enter the following new line(s) between the start mark $PROC and the end mark $, depending on your platform and database:

       3.      Save your entries.

       4.      Under Microsoft Windows, open the Windows Service Manager and stop and restart the service SAPOsCol.

       5.      Under UNIX, restart SAPOsCol manually; to do this, change to /usr/sap/ccms/bin and enter the following commands:

saposcol –k (stops the process)

saposcol –l (starts the process)

Result

The specified process is monitored as of now. To display the results, start the monitor Operating System from the SAP CCMS Monitor Templates monitor set. The information for the process monitoring is in the subtree <host name>  ®  Monitored Processes.

	MSSQL	ORACLE
UNIX		*ora_arc* *ora_reco* *ora_smon* *ora_ckpt* *ora_lgwr* *ora_dbw* *ora_pmon*
Microsoft Windows	*sqlservr.exe*	*oracle.exe*