RE: tempdb

Robert H. Clugston ( (no email) )
Thu, 12 Nov 1998 16:52:06 -0800

Where do I change this? I know when your in SQL enterprise manager and you
go to configure, configuration you get a list of keys and values. Like I
said before I tried changing these before....... and I had to restore my
database from a backup doing business hours. I would like to know what
values to change exactly......
My table so 4 values for every key. Minimum, Maximum, Running and Current.

-----Original Message-----
[] On Behalf Of John Lange
Sent: Thursday, November 12, 1998 4:18 PM
Subject: Re: tempdb


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
>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
--- (_)/ (_)

For more information about this list, including removal,
please see