36GB is a pretty good size, but not too huge (in my opinion). I have a
couple of servers in the 30's and one that is pushing 50GB.  The one at 50
is now making me nervous (disaster recovery/ database restore
considerations),and I am planning to split it into 2 servers in the next
couple of months.

Ben

> -----Original Message-----
> From: Talafous, John G. [mailto:Talafous AT TIMKEN DOT COM]
> Sent: Wednesday, September 01, 1999 5:50 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Performance degradation and Size of database
>
>
> Richard Sims responded:
> >  The consensus is that when your server
> > reaches "huge" size that you subdivide into multiple servers.
>
> Thanks for the response.  When I do a Q DB, I get:
> ANR5965I Console command:  Q DB
>
>
>
> Available Assigned   Maximum   Maximum    Page     Total
> Used   Pct
> Max.
>     Space Capacity Extension Reduction    Size    Usable
> Pages  Util
> Pct
>      (MB)     (MB)      (MB)      (MB) (bytes)     Pages
> Util
> --------- -------- --------- --------- ------- ---------
> --------- -----
> -----
>    36,764   36,764         0     4,988   4,096 9,411,584
> 7,912,982  84.1
> 84.1
>
>
> adsm>
>
>
> The DataBase is at 36.7GB.  Is this "huge"?
>
> John G. Talafous                         Sr. Tech. Prog/Anal
> The Timken Company                 Phone: (330)-471-3390
> P.O. Box 6927                           Fax  : (330)-471-4034
> 1835 Dueber Ave. S.W.
> Canton, Ohio USA  44706-0927
> talafous AT timken DOT com                  http://www.timken.com/
>