Re: Optimize MS SQL & Emerald

Richard Sensale ( (no email) )
Thu, 25 Jun 1998 16:04:52 -0700

We run our SQL and Radius on the same box.
PII 233 128MB RAM, Adaptec Ultra Wide SCSI with a High End Seagate SCSI
drive. We use SQL 6.5 and the radius 2.2. On NT 4.0 SP3, Our response
times are pretty good. I would suggest upgrading your CPU, and RAM and SCSI
does help. Also make sure you have a decent swap file size. ALso try not to
run too much else on the same box. The more the merrier is very applicable
to this box.

Richard Sensale
Network Administrator
VisitUs Internet, Inc.
5468 Schaefer Road
Dearborn, MI 48126 USA
(313) 945-5588
(313) 945-0202 fax
http://www.visitus.net
richards@visitus.net
-----Original Message-----
From: John Lange <radadmin@palacenet.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Thursday, June 25, 1998 7:31 AM
Subject: Optimize MS SQL & Emerald

>HI
>
>I need some advise on this topic...
>
>Please read before you flame me for having such a slow server. That is the
>reason for this eMail.
>
>Currently our SQL Server is the following:
>NT 4.0 sp3
>MS SQL 6.5
>Intel P133
>96 MB Ram
>3GB Ultra DMA IDE
>
>This machine was fine when we only had 500 users, now with 1300 we are
>finding that it isn't filling our needs. We need to optimize our server
>for one specific reason.
>
>1. Running checkdb, nightly maint, truncate, delete start records, and
>other SQL intensive process takes FOOOOOREVER!!! Like 3 hours each.
>
>It auths just fine, reports go OK, and 95% of the time it is overkill,
>because it just sits there at about 5 - 10% utilization.
>
>(Un)-fortunatly, we run SQLMAINT.exe and do a datadump and other process's,
>every night about 3AM and no one can log in during the next 3 hours because
>the server is so busy it won't auth. I have thought about running a text
>file version on the secondary radius server, but I am afraid the text file
>will not get run EVERY night, so new users will not be able to log in.
>
>Is there a way to optimize the servers memory or do something to speed up
>this process. The server is only using about 50MB of the available ram.
>Will increasing it's SQL usage help much?
>
>Our datadumps get to about 300MB before we delete the start records and
>truncate. Will it help to have more ram? More ram alocatted to SQL?
>
>HELP!
>JOhn :}
>
>
>John C. Lange, Sr. PALACE dot NET, INC.
>microjl@palacenet.net MICRO-TECH Computers, Inc.
>608.742.1601 & 6980 2800 New Pinery Road
>http://www.palacenet.net/ Portage, WI 53901
>Visit our online store @ http://www.microt.com/
>Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
>
> --- __o
> --- _-\<,_ Fastest Service in Town
> --- (_)/ (_)
>