How many databases does it take to fill up a databasespace? 
Author Message
 How many databases does it take to fill up a databasespace?

We've been using a 3rd party software package which creates a new database
for each project it manages.  So, after some performance problems they've
called on their friendly neighborhood DBA for help.

We're looking at an upgrade to a new box as well, but more specifically,
changing the way the databases are created.

I'm pretty much from the one-database-per-databasespace school of thought in
the case of many databases in one instance, but am always interested in
hearing what others have to say.  Of course, more databasespaces means more
management of those spaces, but hey, I'm a performance purist.  Holy {*filter*}
retentiveness, Batman!

What do you think out there???

TIA!



Wed, 18 Jun 1902 08:00:00 GMT
 How many databases does it take to fill up a databasespace?

I'll bet your dictionary is sized too small.  ;-)

Quote:

> We've been using a 3rd party software package which creates a new database
> for each project it manages.  So, after some performance problems they've
> called on their friendly neighborhood DBA for help.

> We're looking at an upgrade to a new box as well, but more specifically,
> changing the way the databases are created.

> I'm pretty much from the one-database-per-databasespace school of thought in
> the case of many databases in one instance, but am always interested in
> hearing what others have to say.  Of course, more databasespaces means more
> management of those spaces, but hey, I'm a performance purist.  Holy {*filter*}
> retentiveness, Batman!

> What do you think out there???

> TIA!

--
Madison Pruet

===========================================
Enterprise Replication Product Developement
Dallas, Texas
Informix Software
===========================================



Wed, 18 Jun 1902 08:00:00 GMT
 How many databases does it take to fill up a databasespace?
It depends.  One database|one dbspace improves the granularity of restores
when someone calls you and says: I accidentally deleted all the records in
my project.  Can you restore it from backup?  Since the restore is at best
at the dbspace level.

Art S. Kagel

Quote:

> We've been using a 3rd party software package which creates a new database
> for each project it manages.  So, after some performance problems they've
> called on their friendly neighborhood DBA for help.

> We're looking at an upgrade to a new box as well, but more specifically,
> changing the way the databases are created.

> I'm pretty much from the one-database-per-databasespace school of thought in
> the case of many databases in one instance, but am always interested in
> hearing what others have to say.  Of course, more databasespaces means more
> management of those spaces, but hey, I'm a performance purist.  Holy {*filter*}
> retentiveness, Batman!

> What do you think out there???

> TIA!



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. databases to databasespace

2. filling combo box takes too long

3. Logsegment fills when doing "startserver"

4. Converting full database back-ups to Flat Files

5. Database Back-ups Contending with On-Line Transactions

6. UPS databases

7. how do i access U.P.S. database files of the *.dat type

8. how do i access U.P.S. database files of the *.dat type

9. Slow Database look ups

10. UPS Worldship, how do I fill the reference field from database ?

11. Fill-in does not get filled under Windows NT

12. ADO thinks DBMS is done, but DBMS ain't done


 
Powered by phpBB® Forum Software