Pat Augustine
Interlink America
-----Original Message-----
From: John Lange <radadmin@palacenet.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Thursday, June 25, 1998 4:39 PM
Subject: Re: Optimize MS SQL & Emerald
>HI
>
>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
>>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
>>> --- (_)/ (_)
>>>
>>
>>
>>
>
>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
> --- (_)/ (_)
>