Re: [Emerald] SQL specs

PowerNet ( (no email) )
Mon, 01 May 2000 09:29:56 -0400

Josh,

I run the start records proc every night but I am not sure about the null=
username one.
What is that proc(or SQL query)?

My DB is 500MB and I only keep 2 month of calls records and my size avail=
is 183MB
Weird thing is though on my backup machine which is where the DB is=
transferred every night, the size of the DB is 500MB and space available=
is 357MB

Go Figure!
Any Ideas!

Thanks,
John
BTW.....NT4/SP5 SQL 6.5/SP5a

*********** REPLY SEPARATOR ***********

On 4/30/2000 at 8:17 AM Josh Hillman wrote:

>Back up your Emerald database, then open up ISQL/w using "sa" as the
>username and open the "checkdb.sql" script from your Emerald directory and
>execute it (takes a little while). See if that clears up your problems.
>
>The Emerald.Calls table is what takes up most of the room in your=
database.
>I have a scheduled task run every night that wipes out all START records=
and
>NULL-username records that are older than 3 days. That keeps the table=
from
>growing as quickly. Periodically, I wipe out a month's worth of the=
oldest
>records in the Calls table as well. Even with 1 million records in my=
Calls
>table, my db has never gone over 300something megs.
>
>Josh
>
>----- Original Message -----
>From: Jason <jason@nctc.net>
>To: <emerald@iea-software.com>
>Sent: Friday, April 28, 2000 6:09 PM
>Subject: [Emerald] SQL specs
>
>
>> We currently have about 1600 MBRs. We've been adding about 12 users a
>week
>> for the past year and it looks like that trend will probably continue.
>> Currently our SQL 6.5 is running on a Dell 1300 Dual P2/266 with 196M of
>> RAM. SQL is kicking out all kinds of funky error in the Event Log=
(Error:
>> 806, Severity: 21, State: 1 "Could not find virtual page for logical=
page
>> 976158757 in database 'Emerald'") It does this about 4 or 5 times in a
>row
>> about every 20-30 seconds. Generally I have to reboot the server once a
>day
>> or so. Our RadiusNT in on a separate machine. We're going to be
>investing
>> in SQL7 and a new server to run it on and I guess I want some opinions=
on
>> what to get. Also what would be the best way to migrate Emerald to the
>new
>> server? Our EmerDev.dat file is about 716 megs in size. Does that=
sound
>> right for the number of MBR's we have? We kind of blindly jumped into=
the
>> Emerald deal and it was a quick and dirty install so I know we have like
>10
>> months of call history and such. Whenever I try to manually trim the
>> records it errors out and I have to reboot the server.
>>
>> Any suggestions would be helpful at this point.
>>
>> TIA
>>
>> Jason Roblyer
>> NCTC
>> jason@nctc.net
>>
>>
>> For more information about this list (including removal) go to:
>> http://www.iea-software.com/support/maillists/liststart
>>
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

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