Search active

Number of cursors currently open within the server.

High values result in more memory being used. Growing values can indicate a potential handle leak in the application.

This counter is used to determine memory growth in the server. Many applications are written to do their prepares up front, which is good for performance but can negatively affect memory use. If this number is high, consider reducing the number of concurrent connections or the number of prepares done up front.

Search replan

Number of search replans

A search is replanned when table content is significantly changed. Replan is done to make sure that search plans are optimal for the changed table content.