You are not logged in or registered. Please login or register to use the full functionality of this SYBASETEAM.COM Website...
Current time: 03-12-2010, 09:25 AM Hello There, Guest! (LoginRegister)
Tags: using tmp fs for sybase tempdb,
Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Using Solaris tmpfs for a tempdb Device in Sybase ASE
12-20-2009, 03:54 PM
Post: #1
Using Solaris tmpfs for a tempdb Device in Sybase ASE
Copyright : Sybase,Inc.

Background

Adaptive Server devices usually are raw devices or file system devices. Solaris users have a third option, tmpfs, for tempdb.

tmpfs -- the temporary file system -- caches writes only for a session. Files are not preserved across operating system reboots.
Note:

Other UNIX platforms may allow you to create a temporary file system device. See your operating system System Administrator.

Should you use tmpfs?

To determine whether tmpfs would benefit your system, perform benchmarks comparing the memory assigned to tmpfs versus the memory assigned to the data cache.

Usually, it is more effective to give extra memory to the server for use as general data cache rather than creating a tmpfs device for tempdb. If tempdb is used heavily, then it will use a fair share of the data cache. If tempdb is not used often, then the server can use the memory assigned to data cache for non-tempdb data processing, but if the memory is assigned for tempfs it is wasted.

For more details...

http://www.sybase.com/detail?id=20448
Find all posts by this user
Quote this message in a reply

Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Sybase Database dump failed for a database with no space left on device error padalav 0 174 01-28-2010 10:37 AM
Last Post: padalav
  How to get the max tempdb usage and max log file usage for user database till date GANESHBSUTAR 3 232 01-07-2010 10:49 PM
Last Post: Joshi
  Common Adaptive Server Enterprise Issues on Sun Solaris Joshi 0 217 12-31-2009 04:19 PM
Last Post: Joshi
  find out the size of tables and indexes in any tempdb john 0 184 12-03-2009 05:45 PM
Last Post: john
  Sybase ASE server hung on Solaris and not responding Joshi 0 116 09-09-2009 01:44 AM
Last Post: Joshi
  Query to find device name for each database fragment Nagendra 0 164 07-22-2009 11:06 AM
Last Post: Nagendra
  Using Solaris temp filesystem tmpfs for a Sybase tempdb device Kishor 0 99 07-01-2009 02:11 AM
Last Post: Kishor
  How do I move sybase tempdb off of the Master Device? sybasegeek 0 137 04-27-2009 11:19 AM
Last Post: sybasegeek
  monitor sybase tempdb log space albert 0 787 04-22-2009 01:58 AM
Last Post: albert
  Recovering the master Database or Master Device Nagendra 0 129 04-12-2009 01:56 AM
Last Post: Nagendra

Forum Jump: