In a large or complex FileNet® P8 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
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: