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

PowerNet ( (no email) )
Fri, 29 Oct 1999 09:07:47 -0400

Doesn't SQL 7.0 manage some of these things automatically?

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

On 10/28/99, at 3:54 PM, Ken wrote:

>to check that you right click on the server from enterprise manage and=
click
>on configure and then click on the configurations tab
>
> *********WARNING!!! WARNING!!!**********
>CAREFUL IF THIS SETTING IS TO LARGE FOR YOUR SYSTEM SQL SERVER WILL NOT
>RESTART! BACKUP EVERYTHING BEFORE PLAYING WITH THIS SETTING!
>
>could someone please tell me on a server with 384MB RAM what should I set
>the memory and temdb settings in this configuration to.
>
>Dale please help....
>
>Kenneth Jaeger
>MPC Internet Services
>
>
>
>-----Original Message-----
>From: PowerNet <psc5@powersupply.net>
>To: emerald@iea-software.com <emerald@iea-software.com>
>Date: Thursday, October 28, 1999 2:59 PM
>Subject: RE: [Emerald] SQL Server not fast enhough??? BIG Connection
>Problems
>
>
>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
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

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