Hi,

I am having a doubt regarding one box supporting 6 different databases.
We have seen that there has been a great performance improvement in database1 after tables in database2 were purged.

Is this possible.Please let me know.

Many Thanks,
Shash.

Depends on the database and how it manages its files and the file structure.
In some database files if the files are variable, and growable, they still
have to be managed. In our database Unidata. If the file gets too large it
goes into overflow and if it gets larger it goes into double overflow. So
about once a week, we run a program to check the actual size of the data
compared to the size of the physical file. Then we adjust the parameters of
the file based on the report.

When files go into overflow they are using more memory and virtual memory.
Virtual memory requires more hard drive space. 6 databases may all be using
virtual memory, so the amount of free hard drive space may have a beneficial
impact. Windows needs about 384megs just for minimal virtual memory for the
operating system. XP takes 1gig of space just to install the OS. Every OS
has slightly different characteristics.

On a server Maximum amount of memory might help. More extra Drive space may
help also. Databases have a tendency to grow in size. It is the natural
order of things.

6 Databases may be consuming a lot of resources. It is not only the files
but there may be a lot of resources being used by applications running
against the databases as well.

When we got our new system running we got one server for a production
database and a testing database. Then we have about 3 more database on a
development server where we write the programs. then Sql runs on another
server and then there is a Report Server with some additional applications
running on it. If we write a program and it kills the server it does not
kill the production box.


"shash" <shash.25658z (AT) no-mx (DOT) forums.yourdomain.com.au> wrote