>Hi,
>
>At 08:06 PM 3/24/99 -0600, you wrote:
>>Well we attempted to consolidate yesterday with no such luck.
>>2.5.261
>>
>>Our calls table is huge with 1801136
>>records showing on select count(*) from calls
>>
>>The summary shows 13 periods to consolidate. However, about 30 hours
>>only 15k records were done. Is this typical? At that rate we would
>>never finish consolidating. The SQL server runs on a P2-450, 512MB
>>RAM, RAID5 UW SCSI Array.
>Well, you certainly have sufficient hardware. :) While it was =
consolidating,
>is your hard drive light on a lot? Do you have the tempdb set up in =
RAM? With
>this much available memory I'd give it at least 256 meg and give SQL =
Server 384
>meg. I suspect that would speed things up a bit.
Server setup as follows under configure
memory 131072
tempdb in ram 56
>
>>It seemed to have messed something up after the emerald client was
>>killed...we cannot email invoices out now...it returns an error.
>Did you run a check on the db from ISQL/W?
Didn't run checkdb I think that locks the DB and doesn't allow people
to authenticate and I know it takes quite sometime.
>
>--Ben
>+-----------------------------------------------------------------------=
---+
>+ Ben Conner ben@webworldinc.com =
+
>+ Web World, Inc. (714) 639-0595 voice =
+
>+ PO Box 6548-107 (714) 744-4825 fax =
+
>+ Orange, Ca 92863 =
+
>+-----------------------------------------------------------------------=
---+=20
>
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html