Database monitoring tool usage

In a large or complex Content Cortex system, many database queries can be frequently executed. To find the queries that require tuning, use database SQL monitoring tools to identify slow running queries within the database.

Depending on which database vendor you are using, use these types of tools to identify slow queries:
  • Oracle AWR / ADDM
  • DB2® Snapshots and Event Monitors
  • SQL Server Profiler
Content Platform Engine tools are also available to monitor for slow searches, including:
  • Performance Logging
  • Content Platform Engine Tracing
  • IBM® System Dashboard for ECM
Tip: For information about identifying slow database SQL execution, see technote MustGather: IBMContent Cortex Content Engine Performance External link opens a new window or tab.
When the Database and Search tracing subsystems are enabled, a Content Platform Engine server trace shows the SQL execution time of each database query. For more information, see the following technotes: