RE: [Emerald] Call Consolidation

Duane Schaub ( (no email) )
Fri, 3 Dec 1999 12:49:22 -0600

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: [Emerald] Pool Address"
Next message: Duane Schaub: "RE: [Emerald] Call Consolidation"

I read somewhere that SQL 7 does active caching and uses the available ram
and therefore has no setting. Basically, it is disk based, but the ram
cache does nearly the same thing and you get as much cache as you have
available ram and it is an automatic config.

BTW: Anyone who has not upgraded to SQL 7 is missing out on a DRAMATIC speed
improvement!

Duane.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Emerald
Sent: Thursday, December 02, 1999 9:51 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] Call Consolidation

>
> I have a HP LX Pro, dual Pentium Pros, 512megs and RAID 5 and 700,000
> records takes about 2 hours.....

Most of it seems to be disk activity. The cpu never goes much over 10% usage
and it never maxes out the memory either. But the whole time it's beating
crap out of my disks.

How big is your tempdb? Also, since switching to SQL7 I have not figured out
how to put tempdb in RAM like I did on SQL 6.5, is there a way to do that?

Geo.

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart

Previous message: Dale E. Reed Jr.: "Re: [Emerald] Pool Address"
Next message: Duane Schaub: "RE: [Emerald] Call Consolidation"