Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Optimizing performance on Sybase-ASE-12.5.2
- Thread starter zum
- Start date
Truusvlugindewind
Programmer
Know nothing about sybase but:
- as much RAM as you can afford
- spread your data over as many disks/controllers as you can afford
- use 2.6 kernel
- use direct IO
- use JFS or XFS filesystem for your databasedatadisks (raw disk: even better)
This should be valid for all RDBMS's so it would not hurt sybase.
- as much RAM as you can afford
- spread your data over as many disks/controllers as you can afford
- use 2.6 kernel
- use direct IO
- use JFS or XFS filesystem for your databasedatadisks (raw disk: even better)
This should be valid for all RDBMS's so it would not hurt sybase.
- Status
Similar threads
- Locked
- Question
- Locked
- Question