Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Memory used

Posted on 2004-09-29
6
Medium Priority
?
677 Views
Last Modified: 2013-12-09
Hi everybody,

I have an Interbase 7.1 server running on Windows 2003 Server Enerprise Edition. The machine has 4 GB RAM and is used only for the IB server. The problem is that I cannot force the IB server to use all the available RAM. I have played a lot with the settings in the ibconfig file, but the limit of the memory usage was about 400 MB. I've been executed a lot of "hard" queries, which I think are really memory consuming. I have a database, which files are bigger then 4 GB and I have queries, are affdecting amost all of the tables in the DB, but in the Task Manager I see that the ibserver.exe is first increasing its memory usage very fast, but when it pass the limit of ~400 MB it stop to use more memory and I am waiting for some of the queries more than 3 minutes ...

So, my questin is how I can force the server to use all the availabe RAM on the machine ( when it is required of course ) or we spend our money for 4 GB RAM for nothing.

Thanks in advance
0
Comment
Question by:tkalchev
  • 3
  • 2
6 Comments
 
LVL 10

Expert Comment

by:kacor
ID: 12181433
Hi tkalchev,

everything what I can help you is:

1. look at http://bdn.borland.com/article/0,1410,29632,00.html. You can download from here the InterBase Performance Monitor Release 1.1. This allows you to easily see (and optionally alter) who and what is consuming resources on your InterBase 7 server.

2. On newsgroups.borland.com select borland.public.interbase.general and ask directly the IB developers.

In the meantime I try to search something useful for you

wbr

Janos
0
 
LVL 10

Accepted Solution

by:
kacor earned 375 total points
ID: 12181673
in the borland.public.interbase.general topic search for memory use
0
 
LVL 9

Author Comment

by:tkalchev
ID: 12338400
Hi kacor,

I think with IB 7.1 my problem has no solution, since I can increase the database cache only up to 65535 pages. As I've read, in the new IB 7.5 there will be possibility for a bigger limit. Maybe an upgrade to 7.5 will help.

Regards

Tsvetan
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 10

Expert Comment

by:kacor
ID: 12349010
thank for this info

Janos
0
 
LVL 19

Expert Comment

by:Gary Benade
ID: 12501832
Setting a page cache size of 65535 is not recommended and will probably slow your machine down. A setting of 10000-20000 is the recommended max. Interbase 6 will not use more RAM to do its job even if there is more available - it will do all it's sorting in temporary disk files. I highly recommend you install firebird 1.5.1 and see how that makes a difference - It loves RAM and will use all available ram to do its work if needed (you will need to assign more sort ram in the config file). Bear in mind that these database engines are very optimised and happy in low RAM environments so even your "hard query" might not stress them too much, especially if the query uses indexes and has no grouping and sorting.
0
 
LVL 9

Author Comment

by:tkalchev
ID: 12502270
To hobbit72 :

Where have you seen that I am using Interbase 6 ?!?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question