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

PowerNet ( (no email) )
Thu, 28 Oct 1999 15:49:50 -0400

HOW DO YOU CHECK THAT?

*********** REPLY SEPARATOR ***********

On 10/28/99, at 12:36 PM, Robert H. Clugston wrote:

>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

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart