I typically want to leave about 48mb for the system 64mb preferred). The
number is an upper virtual limit for SQL Server. It usually will not
use
all of that.
> *********** 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
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart