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

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


*********** 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=
>you have at least 128mB of ram dedicated to SQL.
> -----Original Message-----
> From:
>[]On Behalf Of Ken
> Sent: Wednesday, October 27, 1999 3:19 PM
> To:
> Subject: [Emerald] SQL Server not fast enhough??? BIG Connection=
> 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=
>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: