Re: tempdb

John Lange ( )
Thu, 12 Nov 1998 18:17:30 -0600


The setting is in 2k blocks, so if you want 32mb try 16384. You may have
to juggle the numbers a little some times (MB X 1024)*.5 doesn't give a
number that sql likes.

JOhn :}

At 03:56 PM 11/12/1998 -0800, you wrote:
> I want to move my tempdb from disk to ram. I've tried this once and MSSQL
>wouldn't start after I stopped it. I want to know exactly what values to
>change. I've got 128mb of ram and could use up to 32mb of it for the tempdb.
>For more information about this list, including removal,
>please see

John C. Lange, Sr. PALACE dot NET, INC. MICRO-TECH Computers, Inc.
608.742.1601 & 6980 1918 New Pinery Road Portage, WI 53901
Visit our online store @
Authorized iPSwitch WebVar @

--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)