*********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