Microsoft KB Archive/927946
Article ID: 927946
Article Last Modified on 12/12/2006
- ProClarity Analytic Server
This article describes how to monitor performance in ProClarity Analytics Server 6.0, in ProClarity Analytics Server 6.1, and in ProClarity Analytics Server 6.2.
You can monitor performance in ProClarity Analytics Server by using performance statistics. By using performance statistics, you can monitor the connection pool and the cache hit rate. By doing this, you can determine performance in ProClarity Analytics Server.
To run performance statistics, use the following URL to open the Web page in Microsoft Internet Explorer:
ComputerName is a placeholder for the actual computer name.
This Web page contains the following information:
- The number of outstanding connections that exist in the pool and the number of outstanding connections that are currently checked out to run a query
- The percentage of requests for a connection that are satisfied by an existing connection
- The current OLAP security settings
- The overall cache hit rate
By using this information, you can determine performance in ProClarity Analytics Server. For example, you are experiencing good performance in ProClarity Analytics Server if the following conditions are true:
- The number of outstanding connections exceeds 20 in each processor, and the maximum number of connections is 25 in each processor.
- The cache hit rate is not less than 80 percent after an initial warming-up period.
If one or both of these conditions are not true, you should improve the server performance. For example, you can modify the reliance on OLAP security settings, and you can reduce the number of cubes or the number of OLAP roles that you use.
For more information about performance statistics and the Perfstats.asp file that performance statistics uses, see the ProClarity Analytic Server Administrators Guide.
Keywords: kbhowto KB927946