Long Running Queries in Process Monitoring with ILM
Problem
Task search in the Process Monitoring perspective takes too long when ILM is activated.
Solution
When ILM is installed and large amounts of statistic entries are stored in the database, you should use the activation time filter to restrict the search to a particular time frame, thus searching only in the relevant partitions.
For details on applying filters to tasks, see Filtering Tasks.