Memory Resident TempDB was Re: OK, lets be serious
- From: ThanksButNo <no.no.thanks@xxxxxxxxx>
- Date: Tue, 8 Apr 2008 22:53:29 -0700 (PDT)
Hello, Bret --
On Apr 8, 8:47 pm, b...@xxxxxxxxxx wrote:
I believe we are also looking at ways to make tempdb(s)
purely memory-resident with no need for disks at all - but the feature
isn't here yet.
-bret
Somebody told me you could set up a ram-disk, and mount the tempdb on
it.
I tried it without much success. But then, they never told me how it
was supposed to be accomplished.
Someone else told me you could simply install a lot of memory, then
make a very large cache, then assign said large cache to the tempdb.
It's not really a "ramdisk", but Sybase should keep things in the
cache until it's necessary to save it to disk. If the cache is as
large as tempdb, that need will be very rare. This is supposed to
have similar performance to a ramdisk.
I've tried this, and it appears to work, although I haven't
benchmarked it.
Comments?
.
- Follow-Ups:
- References:
- OK, lets be serious - there *must* be a way to do this on ASE
- From: scotty
- Re: OK, lets be serious - there *must* be a way to do this on ASE
- From: Manish Negandhi
- Re: OK, lets be serious - there *must* be a way to do this on ASE
- From: scotty
- Re: OK, lets be serious - there *must* be a way to do this on ASE
- From: bret
- OK, lets be serious - there *must* be a way to do this on ASE
- Prev by Date: How to get info about last dumped transaction
- Next by Date: Re: How to get info about last dumped transaction
- Previous by thread: Re: OK, lets be serious - there *must* be a way to do this on ASE
- Next by thread: Re: Memory Resident TempDB was Re: OK, lets be serious
- Index(es):
Relevant Pages
|
