Re: tempdb

John Lange ( radadmin@palacenet.net )
Thu, 12 Nov 1998 18:17:30 -0600

HI

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:
>List,
> 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 http://www.iea-software.com/maillist.html
>
>

John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 1918 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
Visit our online store @ http://www.microt.com/
Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html

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