Re: [Emerald] TEMPDB IN RAM

Dale E. Reed Jr. ( (no email) )
Tue, 24 Nov 1998 11:45:53 -0800

Robert H. Clugston wrote:
> Every time I try to put my tempdb into ram the server doesn't start when I
> try to restart it. The only setting I changed is the tempdb current setting.
> I changed this to 2044.
> How do I put my tempdb into ram?

Do you have over 2GB of RAM? If you look at the bottom of the window
when changing the value, you'll notive it is in megabytes. :) TempDB
is ram *NOT* included in the SQL memory allocation, either. So when you
add the two together, you must have atleast more ram than those (plus
an OS overhead).

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |