131
CONFIGURING AND ADMINISTERING COLDFUSION 10
Using the ColdFusion Server Monitor
L
ast
u
p
dated
7/9/2
01
2
Application Scope Memory Usage
The Application Scope Memory Usage report lists the application scopes that use the most memory. The detail lists
the application scope variables that use the most memory.
Server Scope Memory Usage
The Server Scope Memory Usage page lists the server scope variables that use the most memory.
Database
The Database section contains the following reports:
Active Queries
The Active Queries report lists all currently active queries that take longer to load than the threshold specified on the
Slowest Queries report. You can view a list or a detailed view.
Slowest Queries
The Slowest Queries report provides the Slowest Queries report and the Slowest Queries by Average report. Both
reports let you identify queries by template name and line number. The slowest queries report shows specific instances
of a query that is slow, along with the SQL statement for the query. The detail view includes the SQL statement. This
information lets you determine why an instance of that query was slow. The Slowest Queries by Average report
indicates queries that are slow on average. This report does not provide the SQL code for the queries because the SQL
statement might vary from one instance of the query to another. Cached queries are not included in either report. To
improve performance, tune the queries listed in these reports. If the result of a query is static, you can improve
performance by caching the query using ColdFusion’s query cache. For more information, see “
Database response
time
” on page 136.
Cached Queries
The Cached Queries report lists the queries that were cached. You can view a list of cached queries or details about an
individual query. If the execution time of a query is low, determine if you really need to cache it. If the execution count
is high, tune the
cachedafter
and
cachedwithin
settings of the query.
Query Cache Status
The Query Cache Status report graphs the number of cached queries, the estimated memory that the query cache
consumes, and the query cache-hit ratio. Performance increases as the query cache-hit ratio increases. If the cache-hit
ratio is too low, you might want to increase the size of the query cache. Alternatively, to analyze how your application
uses the query cache, determine whether you can tune the
cachedAfter
and
cachedWithin
attributes of the
cfquery
tag. If the query cache is too large, determine if you can move some queries out of the cache.
Pool Status
The Pool Status report lists the data sources, whether an application on the ColdFusion server is using the data source,
and the number of connections. You can view a list of data sources or details about an individual data source.
Most Frequently Run Queries
The Most Frequently Run Queries report lists the queries that were made the most. Even if individual instances of a
query run rapidly, tuning queries with a high frequency can result in improved performance. This report does not
provide information about cached queries. You can view a list of queries or details about an individual query.
Errors
The Errors section includes the following reports: