Top call statistics log

When you enable the Top Call Statistics setting on the Logs > Log Settings tab, the TopCallStats.log file is created in the FileMaker Server/Logs/ (FileMaker Server only) or Server/Logs/ (Claris Server only) folder. See Using log settings.

The TopCallStats.log can help identify performance issues with hosted databases, but the logging process may negatively impact server performance. Disable this setting when you no longer need detailed information about the client request operations. When you disable this setting, the TopCallStats.log is no longer updated, and server performance may improve.

To enable top call statistics:

  • In Log Settings, set Top Call Statistics to Enabled.

TopCallStats.log describes the client requests (up to 25) that have the longest elapsed time during the statistics collection interval.

Column name

Description

Timestamp

Database Server timestamp at the collection interval, using same format as the other log files.

Start Time

Timestamp at the start of the remote call (seconds.fraction since the Database Server was started).

End Time

Timestamp at the end of the remote call (seconds.fraction since the Database Server was started). The column will be empty if the remote call is in progress.

Total Elapsed

Total number of microseconds elapsed for the remote call so far.

Operation

The name of the remote call; for example: Query, Upload, or Download.

For some operations, this column includes a task name and the percentage completed; for example: Query (Indexing 10%).

Target

The name of the hosted file that a client has open, with additional data if possible. Possible formats may include:

  • <filename>::<tableID>::<fieldID>

  • <filename>::<layout>

Network Bytes In

Number of bytes received from the client during this collection interval.

Network Bytes Out

Number of bytes sent to the client during this collection interval.

Elapsed Time

Microseconds of elapsed time for the remote call in this collection interval.

Wait Time

Time waiting for other clients (in microseconds) for the remote call in this collection interval.

I/O Time

Time waiting for disk input/output (in microseconds) for the remote call in this collection interval.

Client Name

A client name or identifier; for example, an IP address or FileMaker WebDirect client identifier.

Notes 

  • You can view top call statistics by opening the TopCallStats.log file in any application that can read tab-delimited data.

  • When the size of the TopCallStats.log file reaches the log file size limit, it is renamed TopCallStats-old.log and a new TopCallStats.log file is created.