Subtitles of the Movie

In this movie we'll conclude our discussion of the administration of FileMaker Server 9 and FileMaker Server 9 Advanced running on the Windows Server 2003 platform. Again, we have the console running on Windows XP connected to an instance of FileMaker Server 9 Advanced running on Windows Server 2003. We're in the administration area and we're now looking at the statistics page. If you look at the information at the top of the page, you'll see that it provides a great deal of information about the connectivity types that are occurring in the system. You can see that we have two clients connected via FileMaker Pro, one via Instant Web Publishing, non via custom Web Publishing and none via ODBC or JDBC. And you can see that this gives the current connectivity, the average, the low and the peak. And this information can be very useful for analyzing current conditions on the database server and across the network. If you look at the bottom panel, you see a number of statistics dealing with the databases themselves, including the cache hits and the amount of cache unsaved and a number of other items related to network traffic and a number of items related to the number of open databases that are being hosted. These times that you see here are in microseconds, one-millionth of a second, so here and in the logs, when you want to examine these times, you just have to divide them by a ten to the sixth or one million to get the time in actual seconds. So this fairly large number of 45,434, that's really about four one-hundredths of a second. So you might just want to, on your own server, take a look at these numbers over time, particularly when you have a number of users connected, to see how they change. The data here are very useful for monitoring the overall status of the server and of traffic and we'll have, in the best practices movie, some extensive discussion of what some of these numbers should be in an optimal configuration and what you can do to adjust your server's behavior if some of these numbers start falling well outside the normal and desired range. Additionally, there is extensive discussion in the server administrators guide that comes with FileMaker Server 9 and FileMaker Server 9 Advanced that talks in detail about some of these particular metrics and what they mean in terms of network behavior, network configuration, database structure and architecture and I would recommend that you or your IT administrators, if you're not the IT administrator, may want to take a look at that server administrator guide and particularly the discussion on these particular statistics. So to summarize what we've learned in this particular movie about the statistics pane, we've learned that we can see a great deal of information about the connectivity and client types, including the FileMaker Pro clients, Instant Web Publishing, the various custom Web Publishing options and the ODBC JDBC connectivity. We've also learned that we can get a good deal of information about both the behavior of the database cache on the database server, network traffic and other metrics that can be useful in monitoring and troubleshooting. database cache on the database server, network traffic and other metrics that can be useful in monitoring and troubleshooting.