RE: [Emerald] SQL Server not fast enhough??? BIG Connection Problems

wilson l. chua ( (no email) )
Sat, 30 Oct 1999 16:03:37 +0800

This is a multi-part message in MIME format.

------=_NextPart_000_040F_01BF22F0.5429BC60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

is your sql 7.0? if so, why not just allow it to manage memory dynamically?

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Ken
Sent: Thursday, October 28, 1999 6:19 AM
To: emerald@iea-software.com
Subject: [Emerald] SQL Server not fast enhough??? BIG Connection Problems
Importance: High

I have about 350 phone lines all connecting to various ascend max 4048
They authenticate against a NT Server SQL emerald database.
the server is a PII 450 with 384MB RAM I have it configured to use 160 MB
Ram for SQL server.
I am also running radius NT on the same machine. are there any other
settings for SQL server that could help?

the user dials in connects and on verifying username and password drops.
this only happens alot during peek times.
do I need to change the temp database?

Please help
Ken

------=_NextPart_000_040F_01BF22F0.5429BC60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

is=20your sql 7.0? if so, why not just allow it to manage memory=20dynamically?
 
-----Original Message-----
From:=20 emerald-request@iea-software.com=20 [mailto:emerald-request@iea-software.com]On Behalf Of=20 Ken
Sent: Thursday, October 28, 1999 6:19 =AM
To:=20 emerald@iea-software.com
Subject: [Emerald] SQL Server not =fast=20 enhough??? BIG Connection Problems
Importance:=20 High

I have about 350 phone lines all connecting to =various=20 ascend max 4048
They authenticate against a NT Server SQL emerald=20 database.
the server is a PII 450 with 384MB RAM I have it =configured=20 to use 160 MB Ram for SQL server.
I am also running radius NT on the same =machine.  are=20 there any other settings for SQL server that could help?
 
the user dials in connects and on verifying =username and=20 password drops.  this only happens alot during peek =times.
do I need to change the temp =database?
 
Please help
Ken
------=_NextPart_000_040F_01BF22F0.5429BC60--