User Guide Cancel

View data source metrics

  1. ColdFusion Tools User Guide
  2. Performance Monitoring Toolset
    1. Overview of ColdFusion Performance Monitoring Toolset
    2. Auto-discovery of ColdFusion nodes and clusters
    3. Code profiler in ColdFusion Performance Monitoring Toolset
    4. Configure ColdFusion Performance Monitoring Toolset settings
    5. Install ColdFusion Performance Monitoring Toolset
    6. View cloud metrics
    7. Monitor GraphQL in Performance Monitoring Toolset
    8. Configure TLS/SSL and Authentication for Elasticsearch 8.x  in Performance Monitoring Toolset
    9. View cluster and node metrics
    10. View data source metrics
    11. View external services
    12. View incoming services
    13. View list of sites and busy connections
    14. View topology of sites
    15. Datastore Health Monitoring
    16. Performance Monitoring Toolset Update 1
    17. Secure Performance Monitoring Toolset with HTTPS/SSL
    18. Performance Monitoring Toolset deployment guide
  3. Use ColdFusion Builder
    1. About ColdFusion Builder
    2. System requirements | ColdFusion Builder
    3. Install ColdFusion Builder
    4. Edit code in ColdFusion Builder
    5. Manage servers in ColdFusion Builder
    6. Manage projects in ColdFusion Builder
    7. What's new in Adobe ColdFusion Builder (2018 release)
    8. Frequently Asked Questions (FAQ) | Adobe ColdFusion Builder (2018 release)
    9. Debug applications in ColdFusion Builder
    10. ColdFusion Builder workbench
    11. ColdFusion Builder extensions
    12. Debugging Perspective in ColdFusion Builder
    13. Build mobile applications using ColdFusion Builder
    14. Bundled ColdFusion Server
    15. Debug mobile applications in ColdFusion Builder
    16. Use extensions in ColdFusion Builder
  4. Coldfusion API Manager
    1. Overview of Adobe ColdFusion API Manager
    2. Features in ColdFusion API Manager
    3. Get started with ColdFusion API Manager
    4. Install ColdFusion API Manager
    5. Authentication types
    6. Create and publish APIs
    7. Administrator
    8. Subscriber
    9. Throttling and rate limiting
    10. Notifications
    11. Connectors
    12. Set up cluster support
    13. Integrate ColdFusion and API Manager
    14. Metrics and Logging in API Manager
    15. Generate Swagger documents
    16. Configure SSL
    17. Known issues in this release
    18. Policies in ColdFusion API Manager
    19. Create a Redis cluster
    20. Multitenancy in API Manager
    21. Docker images for ColdFusion API Manager

The Performance Monitoring Toolset can monitor a heterogeneous database server environment that consists of all the ColdFusion-supported databases. It helps users in identifying the bottleneck at the database or data source level. It can pin point the ColdFusion queries which are slowing down the entire ColdFusion application, so that developers or database administrators can take the appropriate step to fix these bottlenecks.

Database monitoring is divided into multiple sections, as follows:

  • Database overview.
  • Data source details page.
  • Query details page.
  • Actively running queries.
  • Database Pool statistics.
List of data sources
List of data sources

The Database overview page contains the following charts:

Average query time

This chart shows the average query execution time per data source. Only five data sources are displayed by default.

You can view the time taken by a query to execute.

Average query time
Average query time

Throughput

This chart shows the number of queries executed per unit of time.

Throughput
Throughput

Top slow queries –This metric helps in nailing down the query in the ColdFusion application that executes the slowest. You can see a sorted view of all the queries in descending order.

This report helps identifying queries by template name, application name, and line number. On clicking a query, you are redirected to the specific instance of a query that is slow, along with the SQL statement for the query. You drill down to the detailed query page to investigate it further.

To improve performance of these queries, you must tune the queries listed in this table. If the result of a query is static, you can improve performance by caching the query using ColdFusion’s query cache.

Top slow queries
Top slow queries

You can use the metrics from the sections below to know the performance of your queries.

Query details

The section displays detailed information about the SQL statement, template path, line number, and the time taken to execute the query. The Query detailed page has three tabs:

  • Basic info
  • Invocations
  • References

To know more, click the required query in the Top slow queries chart.

The Basic info tab contains the following:

  • Name of the data source.
  • Name of the query.
  • Time taken to execute.
  • The template from where the query was served.
  • Application
  • Start and end times of query execution.
  • Whether the query was cached.
  • Query execution status.
  • The SQL statement.
  • Type of SQL statement, for example, SELECT, UPDATE, and so on.
  • The URL of the query.
  • The instance from where the query was executed.
  • The thread ID of the execution.

The Invocations tab contains the following:

  • The SQL statement that executed the queries
  • The minimum and maximum execution times of the queries
  • The number of times the query is called

The References tab contains the URLs of the queries and the number of times the queries are called.

Data source details: The section contains details about the data source. It has information like database name, database server name, database host name, and database port.

Click any data source for the information.

Most frequently run queries

This chart displays a list of queries that you run most frequently. You cal also see the average time taken by a query to execute, and the number of times the query has been executed.

Most frequently run queries
Most frequently run queries

For more information, click any query.

The Basic Info tab contains the following details:

  • Name of the data source that your query uses.
  • The name of the query.
  • The time taken by the query to execute.
  • The template from where the query was served.
  • The application that contains the template.
  • The start and end times of the query execution.
  • The status of the execution.
  • The SQL statement.
  • The type of SQL statement- SELECT, UPDATE, etc.
  • The URL of the query template.
  • The ColdFusion instance from where the query was served.
  • The Thread ID of the execution.
Basic info- Query
Basic info- Query

The Invocations tab contains the following information:

  • The SQL statement used in the query.
  • The number of times the query was executed.
  • The summary statistics of the execution.

The References tab contains the URLs of the queries and the number of times the queries are called.

Query cache

This chart displays 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 the query needs caching.

To drill down to a more detailed page, click the pie-chart.

Queries per node: This chart shows all the ColdFusion queries executed across all the ColdFusion nodes as part of cluster or group.

You can drill down to more details, as shown below:

Queries per application: This chart shows the distribution of ColdFusion queries executed for various ColdFusion applications.

Click to drill down for more information.

SQL distribution

This chart categorizes all the ColdFusion queries according to the data manipulation language like, select, insert, update, and delete. It helps you to understand the kind of queries that are being used on a ColdFusion data source.

Click to drill down for more information.

CF transaction

This chart shows the distribution of success or failure of a cftransaction tag. This tag allows DBMS for treating multiple database operations into a single transaction. It provides commit and rollback processing of a DBMS. 

Click to drill down for more information.

 Adobe

Get help faster and easier

New user?