Optimize MS SQL & Emerald

John Lange ( radadmin@palacenet.net )
Thu, 25 Jun 1998 14:34:49 -0500


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

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