Re: tempdb

Dale E. Reed Jr. ( (no email) )
Thu, 12 Nov 1998 17:38:11 -0800

John Lange wrote:
> 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.

Tempdb is in MB NOT 2k blocks. Memory is in 2k blocks.

> > 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.

Make sure that the total of memory allocated (in 2k block) plus the
memory allocated to tempdb (it is *NOT* included in the memory of
SQL Server itself is less than 80% of your physical RAM.

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