NOTE: Applies to geodatabases created with an ArcGIS Server Enterprise license only
When troubleshooting an ArcSDE service, you might want to display statistical information about the service or about all the current user connections.
To display information about the current user connections, you use the –I users option with the sdemon command. The following process information appears for each registered ArcSDE client when you issue the sdemon command with the –I users option:
- S-ID—Process identifier
- USER—User name of client
- HOST:OS—Name of the host computer and operating system (OS)
- STARTED—Name and time the process started
To display statistic information about the service, you would first need to set up your ArcSDE geodatabase to store statistics in the PROCESS_INFORMATION table. Writing statistics to the PROCESS_INFORMATION table can have a negative impact on performance, so you should only enable this if you need the statistics for troubleshooting purposes.
Once the PROCESS_INFORMATION table is storing statistics for the tasks or sessions you want to troubleshoot, you can use the sdemon –o info command to display the statistical information stored in the PROCESS_INFORMATION table.
You would use the sdemon command with the stats option to display statistics about the ArcSDE service. The output of the sdemon command with the stats option includes
- S-ID—SDE session identifier
- OPS—Number of client/server operations
- READS—Number of features/identifiers read from disk
- WRITES—Number of features written to disk
- BUFFERS—Total number of buffers sent to client task
- PARTIAL—Number of features sent to client that were larger than the buffer size
- F/BUF—Average number of features/identifiers per buffer
- BUF AVG—Average buffer size in bytes
- TOT Kbytes—Total kilobytes of data sent to client
- Set the PROCSTATS initialization variable to a number greater than 0.
The process statistics parameter controls the interval by which sessions update the PROCESS_INFORMATION table. By default, this parameter is set to -1, which disables entries to the PROCESS_INFORMATION table. To enable entries, set the parameter to a positive integer that reflects the interval, in seconds, in which the sessions will write their statistics to the table. The interval represents the time that must pass before the session last wrote statistics. The session will only write statistics if a change has occurred.
To change the PROCSTATS value, use the sdeconfig administration command with the alter operation. For example:
sdeconfig –o alter –v PROCSTATS=4
For details on how to use this command, read the sdeconfig topic in the ArcSDE Administration Command Reference provided with the ArcSDE component of ArcGIS Server Enterprise. You can also download a PDF version of the file from the Geodatabase Resource Center (login required).
- Connect to the geodatabase using an ArcSDE service and perform the tasks for which you want to collect statistics.
- Use the sdemon –o info –I stats command to display the statistics.
sdemon –o info –I stats
ArcSDE Instance gis Server Process Statistics on luke at Tue May 8 10:37:14 2006
S-ID OPS READS WRITES BUFFERS PARTIAL F/BUF BUF AVG TOT Kbytes
12566 111 1278 0 12 0 106 6K 80K
At the command prompt, issue the sdemon command with the info operation and users option. For example:
sdemon –o info –I users
ArcSDE Instance esri_sde Registered Server Tasks on luke at Tue May 9 11:10:51 2006
S-ID User Host:OS Started
90 bob buru:Win32 Tue May 9 09:29:52 2006
926 RJP chris:Win32 Tue May 9 10:33:44 2006
1040 vtest kayak:Win32 Tue May 9 11:10:21 2006
