SQL/NT memory configuration parameters

[jimmy]

Can someone tell me if this sounds OK?:

NT4 SP5 running SQL6.5

Physical Memory - 512mb
Virtual Memory - 1024mb

Allocated to SQL - 256mb

The largest database is 7gb and tempdb (in ram) is 150mb

Do as a rough guide these figures seem OK?

[Ray Miao]

I'll not put tempdb in ram. If it's dedicated sql server, allocate more ram to sql.


------------
jimmy at 12/13/2001 9:37:31 AM

Can someone tell me if this sounds OK?:

NT4 SP5 running SQL6.5

Physical Memory - 512mb
Virtual Memory - 1024mb

Allocated to SQL - 256mb

The largest database is 7gb and tempdb (in ram) is 150mb

Do as a rough guide these figures seem OK?

[derek]

i have pretty much the same config, but need to increase tempdb. currently i have 150 (data + log) in ram. my questions are:

1) if i allocate say another 500mb of disk space to tempdb, is that ok, considering the first 150 is in ram?

2) in it isn't ok, can i remove tempdb from ram and have it purely as say 650mb of file?

3) what are the basic differences between having tempdb in ram or as disk space?

thanks in advance

derek

[rmiao]

1. You can put tempdb either in ram or on disk, not both.

2. Yes.

3. Check 'when to use tempdb in ram' in books online. I never put tempdb in ram since you get better performance with those amount of memory as data cache.

[skhanal]

If you can separate tempdb in a different disk than data files, that will work out best for you.

I agree with rmiao on not putting tempdb on RAM.