[Emerald] SQL specs

Jason ( (no email) )
Fri, 28 Apr 2000 17:09:45 -0500

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