Re: [NTISP] SQL Server memory usage

Dale E. Reed Jr. ( (no email) )
Tue, 02 Mar 1999 13:31:45 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Terry Bomersbach: "Re: [NTISP] trace routes on Livingston equipment"
Next message: HERVE_GRAND@HP-Switzerland-om3.om.hp.com: "[NTISP] EMC, HP Netserver, Fiber Channel"
Maybe in reply to: Josh Hillman: "[NTISP] SQL Server memory usage"

Josh Hillman wrote:
>
> When configuring SQL Server, is the "tempdb in ram" value part of the RAM
> allocated in the "memory" section or is it a different chunck of RAM? In
> other words, if I have SQL Server set to use 150MB RAM ("memory" = 75000),
> and set "tempdb in ram" to use 40MB, is that 40 part of the 150 or no?
>
> Dual Pentium 200, 256MB RAM
> SQL Server 6.5 SP4 (soon to be 5)

Its seperate. You add the two together to get the total.

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list, including removal,see this url: http://www.iea-software.com/maillist.html

Previous message: Terry Bomersbach: "Re: [NTISP] trace routes on Livingston equipment"
Next message: HERVE_GRAND@HP-Switzerland-om3.om.hp.com: "[NTISP] EMC, HP Netserver, Fiber Channel"
Maybe in reply to: Josh Hillman: "[NTISP] SQL Server memory usage"