>Hi All,
>
>Is there a way that I can measure the performance of my FoxPro database and see what is happening on the different files and table when data is accessed.

Sorry, this does not answer your question, but I wanted to throw this comment out there... This is one of the greatest benefits I gained when I converted my app from DBF files to Sql Server Express. There are tons of monitoring tools in the Sql Server platform and you can see *every* query, insert, update that comes through the database, as well as performance data, query plan, indexes used, etc.

Even besides a Sql Server conversion, while you data is still on DBFs, you can achieve similar logging/reporting/analyzing if your were to use Business Object methods to do all the queries. This gives you a hook point where you can log each query and time it as well. This was the this step I took, and I used the wwBusiness class from West Wind Technologies, although, you can write you own without too much work. Just write a base business object class that has logging and timing coded into it, then place all your queries in sublclasses of this main class.