Re: Optimize MS SQL & Emerald

John Lange ( )
Thu, 25 Jun 1998 15:42:00 -0500


This machine I can afford.

How long does Dale's checkdb.sql take to run on your system and how much
data do you have?

Our Secondary Radius Server sometimes looses it's connection while running
these process, so unloading radius from the SQL server probably won't help.

JOhn :}

At 04:04 PM 6/25/1998 -0700, you wrote:
>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
>-----Original Message-----
>From: John Lange <>
>To: <>
>Date: Thursday, June 25, 1998 7:31 AM
>Subject: Optimize MS SQL & Emerald
>>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?
>>JOhn :}
>>John C. Lange, Sr. PALACE dot NET, INC.
>> MICRO-TECH Computers, Inc.
>>608.742.1601 & 6980 2800 New Pinery Road
>> Portage, WI 53901
>>Visit our online store @
>>Authorized iPSwitch WebVar @
>> --- __o
>> --- _-\<,_ Fastest Service in Town
>> --- (_)/ (_)

John C. Lange, Sr. PALACE dot NET, INC. MICRO-TECH Computers, Inc.
608.742.1601 & 6980 2800 New Pinery Road Portage, WI 53901
Visit our online store @
Authorized iPSwitch WebVar @

--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)