Posted: 12 Mar 2019 12:37 EDT Last activity: 9 Apr 2019 1:42 EDT
AES Top performance Items
We updated AES from 717 to 731 and restarted the training env for monitoring.In top performance items, I keep getting the below db item and other related DB tables. I am not sure whether its saying DB - table is not performing well or anything wrong with the AES- train env set-up as the message says about declare page. Any help is highly appreciated!
Verify that the monitored nodes in this system are operating and reachable, so that this <Declare_AESSettings.Description> serve... SQL:INSERT INTO Data.pr_sys_queue_ftsindexer
rather unusual that inserts into the ftsindexer table are slow. Most often, the inserts are fast, but the queries (run through a stored procedure) are slow. The fts indexer table is highly volatile -systems insert to the table any time a case is updated or crated; the fts indexer agents query, update and delete the table entries. By default Oracle and Postgres do not free up / re-use space from deleted rows immediately, and the table might 'bloat' with relatively small row counts taking up tons of space and degrading both query and insert/update performance. Engage DBA and look at row count and space used by the table