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

Robert H. Clugston ( (no email) )
Thu, 28 Oct 1999 12:36:00 -0700

This is a multi-part message in MIME format.

------=_NextPart_000_0017_01BF2140.FDAA8E60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Makes sure that you have the tempdb in ram (this setting is in MB) and that
you have at least 128mB of ram dedicated to SQL.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Ken
Sent: Wednesday, October 27, 1999 3:19 PM
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_0017_01BF2140.FDAA8E60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

Makes=20sure that you have the tempdb in ram (this setting is in MB) and that =you have=20at least 128mB of ram dedicated to SQL.
-----Original Message-----
From:=20 emerald-request@iea-software.com=20 [mailto:emerald-request@iea-software.com]On Behalf Of=20 Ken
Sent: Wednesday, October 27, 1999 3:19 =PM
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_0017_01BF2140.FDAA8E60--