December 4, 2003 at 3:50 pm
I was pondering moving empdb to reside in memory. Running SQL 2000 SP3 on advance server with 8 G memory.
The memory is not being used to full capacity and I was wondering if moving tempdb to RAM would give us any performance gain.
I'm new to the idea and am just looking for some feedback of whether to even consider this path or not. And things to be careful of.
Thanks
K
December 5, 2003 at 10:13 am
I wish I knew...I'm going to follow this thread and hopefully some good input will be found 🙂
Neat question...not even sure how you could get it into memory..
"Keep Your Stick On the Ice" ..Red Green
December 5, 2003 at 10:46 am
Does that option even have an effect in SQL2k? I thought it was already in ram in versions > 6.5?
December 5, 2003 at 11:40 am
Yes you are correct, didn't read close enough on the version chart.
It is no longer a supported option.
December 5, 2003 at 1:15 pm
Configuration Options in BOL:
tempdb in ram placed the tempdb database in RAM, if needed. No longer supported because SQL Server 2000 has been optimized for maximum performance.
Remove all references to tempdb in ram.
Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.
Patrick
Quand on parle du loup, on en voit la queue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply