Re: Call Consolidation

Dale E. Reed Jr. ( (no email) )
Wed, 10 Dec 1997 23:03:43 -0800 ()

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 |