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
> --- (_)/ (_)
>