Good hardware platform to support 50+ DB users

Good hardware platform to support 50+ DB users

Post by Kevin Me » Thu, 04 Jun 1992 23:30:18



We are currently using (don't laugh) an AT&T 3B2/600 for a
database application that is growing in popularity.
Response time gets very slow when you have more than 10-15
concurrent users running our database application.

This has put us in the market for a faster hardware platform
for our Database applications.  

I was wondering what recommendations people had for machines
that can support 50+ concurrent users running database applications
whithout noticable performance degredation.

Most users are doing mild data entry and heavy report generation.
BTW our database is Unify 2000 ( about 75M ) and our application
is written in ACCELL 4GL.

Information including the following would be greatly appreciated.

Machine and Model:
OS version:
Amount of RAM:
Disk Size and type:
Typical number of concurrent users:
Other comments about performance:

Thanks,

Kevin

--
Kevin Meek

 
 
 

Good hardware platform to support 50+ DB users

Post by Gary J. Haberma » Fri, 05 Jun 1992 09:54:53


|> Information including the following would be greatly appreciated.
|>
|> Machine and Model:
|> OS version:
|> Amount of RAM:
|> Disk Size and type:
|> Typical number of concurrent users:
|> Other comments about performance:
|>
|> Thanks,
|>
|> Kevin
|>
|> --
|> Kevin Meek

Kevin,  We are currently supporting 50-60 heavy db users on our CDC 4680.  

System :  CDC 4680
OS         : EP/IX 1.4.3
Ram      : 128M
Disk       : 2 1 GIG SCSI drives
users       : 50 -60  heavy database inquiry,  3  people doing development

The database is about 175,000 records and takes aroud 850M

We have had the system for about a year and haven't been able to slow it down.  We only  have
one cpu, but you can have upto 4.  Here are the SPECMark/ Specthruput numbers, compared
to 4 other vendors.

                                                   CDC                 DEC           HP                IBM             SUN
                                                 4680                   5800            750               950             690MP
Maxinum #  cpu's                        4               4       1       1       4
SPECMARK                   205                    39                 78                72                91
Aim Users load                       1381                  65 (1 cpu)        
TPC-C(ORacle)                      112 (2 cpus)    
Max Disk Capacity  (GB)       179                   58                  40               22                52

We have been very happy with performance, so much so, we have recommed the purchase
of a 3 cpu model with 256M  memmory and 14 gig of disk to replace our current  administrative
system.
CDC has a whole line of 4000's system, ranging from a work station to the system's I just mentioned.

If you would like any  more information, just drop me a note.

I hope this help's

Gary
--------------------------------------------------------------------------------


Widener University, Chester Pa.    Phone    : (215) 499 - 1044

 
 
 

1. pci ultra scsi cable to 50 pin scsi ii (vhdc ro 50 pin)

Hi,

I've got a PCI ultrascsi host adapter in an ultra5 - this came with a
a cable (vdhc1 to scsi 68), however at this moment in time I only have
50 pin scsi devices to connect to it

So is there a vdhc1 to 50 scsi cable availalbe - I've only found the
68pin version. I guess this feels like a retrograde step but it;s not
feasible to buy a 68 pin device just so that I can then use a 68-50
pin cable to chain my existing external disks.

And is it only me (probably)  but do these vdhc connectors feel flimsy
to you?

Many thanks, any info appreciated
shin

2. Apache 1.3.12 Released

3. Looking to buy a good modem for 50 bucks, Recommendations?

4. problem with ftape

5. RAID 50 good or bad???

6. HELP silicom ethernet card

7. Install NetBSD on Sun3/50 - a good idea?

8. copy and paste

9. Make Your H/50 & F/50 haul ASS!

10. Solaris(TM) X86 Hardware Platform Support

11. What would be a suitable unix hardware/software platform for 200+ Users

12. Summary: Running 50 to 100 or more users?

13. Help! 50 remote users