When you enable the Top Call Statistics setting on the Configuration > Logging tab, the TopCallStats.log file is created in the FileMaker Server/Logs/ folder.
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.
•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: |
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. |
•The Top Call Statistics setting is automatically disabled when you stop the Database Server.
•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.