Performance degrades when actively working with databases bigger than the
available RAM amount
----------------------------------------------------------------------------------------------
Key: CORE-3791
URL: http://tracker.firebirdsql.org/browse/CORE-3791
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1, 2.1.4, 2.5.0, 2.0.6, 3.0 Initial, 2.1.3, 2.1.2,
2.0.5, 2.1.1, 2.1.0
Environment: Firebird (both 32-bit and 64-bit) on Windows 64-bit hosts.
Windows 2008 and Windows 7 are known to be affected, Windows 2003 R2 is
suspected.
Reporter: Dmitry Yemanov
With the random file access requested, the Windows file-system cache is growing
so that it could fit all the accessed pages. If the whole database is being
accessed (e.g. by the backup process or just very random I/O pattern) and its
size is larger than either the configured FileSystemCacheSize setting or the
available RAM size, the swapping occurs. In the worst case it leads to the
shrinked working set of the Firebird server itself but sometimes even Windows
itself can go out of the available physical memory and crash.
Confirmation by Microsoft:
http://support.microsoft.com/kb/2549369
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
