Subject | server memory usage on database restore |
---|---|
Author | Gary Benade |
Post date | 2004-06-02T07:15:04Z |
I have a server running WinXP Pro with 750mb of ram
When I restore a database the server maxes out on ram, with only about 20K of memory free. This starves my server apps that are trying to serve clients connected on other databases.
db size doesnt really matter, but my databases are around 1GB,
The server is configured for 20000 8kb page buffers, which means firebird should not use more than 160MB of ram for the restore.
I did notice that a large part of the ram is being used by the system cache - what causes this?
The machine is configured for background process priority and memory usage favours programs in performance settings
thanks in advance
Gary
[Non-text portions of this message have been removed]
When I restore a database the server maxes out on ram, with only about 20K of memory free. This starves my server apps that are trying to serve clients connected on other databases.
db size doesnt really matter, but my databases are around 1GB,
The server is configured for 20000 8kb page buffers, which means firebird should not use more than 160MB of ram for the restore.
I did notice that a large part of the ram is being used by the system cache - what causes this?
The machine is configured for background process priority and memory usage favours programs in performance settings
thanks in advance
Gary
[Non-text portions of this message have been removed]