Viewing client statistics
Use the Statistics > Clients tab to monitor server performance and diagnose the causes of FileMaker Server performance problems. Admin Console displays client statistics collected during remote calls made by each FileMaker client, all
Web Publishing Engine clients, and all ODBC and JDBC clients to FileMaker Server.
If you select
Log client statistics while the Clients tab is selected,
the client statistics are collected and logged in the ClientStats.log. The ClientStats.log is created in the FileMaker Server/Logs/ folder. Because it is a tab-delimited text file, you can view the ClientStats.log in FileMaker Pro, a spreadsheet, or a text editor. If you stop Admin Console, FileMaker Server automatically stops collecting and logging client statistics. See
Viewing log file entries.
Note If you use the Statistics > Clients tab in larger deployments, FileMaker Server performance may be adversely affected. Use the Statistics > Clients tab only when needed to troubleshoot FileMaker Server performance problems.
To view client statistics:
1. Click the Statistics > Clients tab.
2. To pause the update of client statistics in the Statistics > Clients tab, click Pause.
3. To log the client statistics, select Log client statistics while the Clients tab is selected.
Statistic | Description |
Client | For a FileMaker Pro or FileMaker Go client, the user login name is displayed. For all Web Publishing clients, WPC is displayed. For all ODBC and JDBC clients, XDBC is displayed. Position your cursor over the name in the Client column to display the machine name and IP address of the client. |
Remote Calls | Number of remote calls completed. Note that there can be multiple remote calls to perform a single operation from the client's perspective. |
In Progress | Number of remote calls which are pending completion. The start of the remote call can be during the current collection interval or the previous interval. |
Elapsed Time | Elapsed time (in microseconds) of a completed remote call or an in-progress remote call. |
I/O Time | Time (in microseconds) spent by the client’s thread waiting for input and output to complete. |
Wait Time | Time (in microseconds) spent by the client’s thread waiting for other threads or resources. |
Net Bytes In | Number of bytes received from the client to FileMaker Server (data requests). |
Net Bytes Out | Number of bytes sent to the client from FileMaker Server (notifications). |
Pausing and resuming update of client statistics
FileMaker Server updates the client statistics on the Statistics > Clients tab at the time interval specified for the statistics collection interval. You can click Pause to pause the update of the statistics on the Statistics > Clients tab so that you can inspect the data. Click Resume to display the latest client statistics and continue updating.
To reduce the overhead required to calculate statistics, you can increase the interval between each time FileMaker Server collects statistics. However, the client statistics then become approximations of how FileMaker Server is actually using system resources. For information on configuring the statistics collection interval, see
Logging and statistics settings.
Notes
• Each row of the Statistics > Clients tab displays the statistics for an individual FileMaker client or the total statistics for all Web Publishing clients and all ODBC and JDBC clients. Web Publishing clients includes FileMaker WebDirect connections and Custom Web Publishing (PHP, XML) connections.
• If a client is disconnected anytime during the statistics collection interval, the statistics for that client are not displayed on the Statistics > Clients tab.
• The following types of information are not included on the Statistics > Clients tab:
• Operations that occur only on the client, such as sorting data that has already been downloaded to the client.
• Local operations that occur on the machine hosting FileMaker Server, such as backups, server-side scripting, or schedules.
• To sort items on the Statistics > Clients tab in ascending or descending order, click a column heading.
• To resize the width of a column, select the column heading border and drag it horizontally.
• To put the columns in a different order, click a column heading, drag it, and drop it at the desired location.
Related topics