> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of John Lange
> Sent: Thursday, June 25, 1998 9:35 PM
> To: emerald@iea-software.com
> 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
> --- (_)/ (_)
>