Configuration tips to multi database environment

[MarkoAntila]

We are using an third party application which is running on Progress 9.1E database. What is special in this application is that it contains a huge amount of separate databases. We are now having nearly 300 separate databases in one and same server. This is also a unique installation to the vendor which has provided this application and for that reason they cannot give good suggestions how to configurate this kind of environment.

Do you have experience in similar environment where the number of physical database on one sever is so huge? We are having problems with the capasity of the server and I would really like to hear some configurations tips for this environment.

 

[paulb@ccs.nl]

Which operating system are you using?

On Windows server you will pass the maximum count of processes. I guess it won't work, otherwise you will see poor performance. The maximum count of databases on a Windows server is 100. Above 100 you will see too much disk-access and too much processes.

On unix you have a better chance it will work. I have no expirience with lots of databases on unix.

 

[TomBascom]

Why do you have so many databases? If it were me I'd be looking real hard at ways to consolidate the databases.

Beyond that you need very careful planning, analysis, scripting and reporting. (Which are very good ideas anyway...)

You say that you're having capacity problems - what sort? Error messages on db startup? Users complaining? Random crashes? A vague feeling that you're spending too much money for too little performance?

This may be self-serving (ok, it is) but it sounds to me like you need some consulting help.