Discussion:
backupserver tuning documentation
(too old to reply)
Max DBA
2009-02-12 14:26:12 UTC
Permalink
Raw Message
Hi,
I'd like to do some tuning on backupserver but I am not able
to find documentation except in utility guide where a very
shord description of configuration parameters is present.
Do You have any link or document?
Derek Asirvadem
2009-02-14 14:30:45 UTC
Permalink
Raw Message
Yes, you can certainly make dumps/loads fly.
Try Sys Admin Guide Vol I ch 12.
--
Cheers
Derek
Senior Sybase DBA / Information Architect
Copyright © 2008 Software Gems Pty Ltd
--
Tired of databases that are more cost than benefit ? Wondering why you
cannot get Sybase performance from Sybase ? Find out
Peter Collard
2009-02-19 09:03:37 UTC
Permalink
Raw Message
Post by Max DBA
Hi,
I'd like to do some tuning on backupserver but I am not able
to find documentation except in utility guide where a very
shord description of configuration parameters is present.
Do You have any link or document?
The most important issues are disk related. Basically the input limitation
to backupserver is the physical disks your database sits on, and whether
Sybase can identify them. So if you have 5 physical disks in 1 logical
volume its better to have defined 5 devices even though it may seem a
nonsense as this allows the backupserver to run 5 input threads.
In terms of outputs you want stripes to at least match the number of
physical disks, but this gets much more complicated when disk caching of
SANs etc is taken into account. Generally I've found its suck it and see on
output threads(stripes) - but they are easy to change, unlike the input
threads.

Loading...