Subject Re: [firebird-support] Re: Negative impact on system performance querying monitoring tables.
Author Marcelo Guimaraes
Thanks all for the clarify!

Marcelo Guimarães

Em sex, 4 de out de 2019 às 10:19, Dmitry Yemanov dimitr@... [firebird-support] <> escreveu:
04.10.2019 15:50, Mark Rotteveel wrote:

> The problem is inherent to the monitoring tables. If you query one
> monitoring table, Firebird needs to collect and prepare a snapshot of
> the data for all other monitoring tables to be able to provide a stable
> and consistent view of the monitoring tables in your current
> transaction. If you do this a lot, then it will need to repeatedly spend
> that time, which can have an impact on performance, because the cost of
> that data collection is non-zero (.
> So, the problem can't really be fixed, because that data collection will
> need to happen and doing the collection takes time (CPU) and memory.

Just an addition:

In v2.5, pending MON$ requests could also [temporarily] block other
connections' operations, thus decreasing the overall performance. This
was improved in v3 to reduce the cross-locking with other connections.

But generally, your message is absolutely correct.





Visit and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at


Yahoo Groups Links

<*> To visit your group on the web, go to:

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    (Yahoo! ID required)

<*> To change settings via email:

<*> To unsubscribe from this group, send an email to:

<*> Your use of Yahoo Groups is subject to:


Marcelo Guimarães