05.01.2013 11:59, Vlad Khorsun wrote: > In general, pages are written as result of > a) page cache preemption (when new page should be read into cache > and least recently used page is dirty) > b) precedence writes (when some dirty page is about to be written > it forced writes of all pages it dependent on) > c) another attachment in CS\SC asks our attachment to release the > page lock we own and page is dirty in our local cache > d) flush at commit\rollback\end_of_sweep\detach
So, if I understand correctly, if there is a lot of garbage in database, sweep with GC touch a lot of pages and almost any activity in parallel connections cause massive page flush. Exactly the behavior observed by TS. -- WBR, SD. ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122912 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
