Re: Call Consolidation

Michael Whisenant ( )
Thu, 11 Dec 1997 09:36:58 -0600

I would be game to this test. Can you explain the possible risks?
Downtime, etc???

At 11:03 PM 12/10/97 -0800, you wrote:
>On Wed, 10 Dec 1997, Michael Whisenant wrote:
>> >Most likely the issue was the size of your tempdb, not the locks.
>> >I ran into an issue here today where I was doing a consolidation on
>> >about 800,000 records, and it kept telling me I was out of locks, but
>> >I didn't beileve it. After raising the size of tempdb to 40mb (from
>> >20mb) it ran fine.
>> But as your know my tempdb was increased as a measure to solve this to
>> 300mb already. Therefore I am unclear about this?
>Emerald just doesn't use that many locks for consolidation. The one
>thing I would like to try and see is if its a database issue. I've
>seen a lot of problems disappear by do an SQL transfer of the data
>into a new database (especially page allocation problems). If you want
>me to give that a test let me know.
>Dale E. Reed Jr. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |
> ----------------------------------------------------------
> Emerald Mailing List