To answer part of your original post, below are the routine tasks that I
follow. Others administrators will have different tasks and priorities. It
depends on your business requirements. I have 22 ASE servers (versions
11.03, 11.9.2, 12.0, 12.5) all run almost identical scripts and procedures.
A number of the scripts and procedures to accomplish these tasks can be
found via the previously posted links.



Daily - backup each database

Daily (and as needed via threshold processing) - dump transaction log

Daily - check success of nightly backups

Daily - check available of space in each database segment (watch trends)

Daily - check ASE server error log using egrep -f ${WORRIES} WORRIES is a
file containing key words to pull messages

Daily (twice) - run sp_sysmon and save to file



Hourly - Run and record elapsed time for a standardized set of DDL to
measure performance as seen by a user

Hourly - save current value of ( @@connections , @@cpu_busy , @@idle ,
@@io_busy , @@pack_received , @@pack_sent , @@packet_errors ,

@@timeticks , @@total_errors , @@total_read , @@total_write , @@trancount ,
@@servername )



Weekly - Print / plot max, min, avg response time from hourly checks to
monitor trends, etc.

Weekly - check high water mark for concurrent users in syblicenseslog

Weekly - extract DDL using DDLGEN and homegrown tools/procedures

Weekly - print chart showing daily/hourly changes of @@connections and
@@total_read (others available by special run)

Weekly - run dbcc checkstorage on all databases

Weekly - test each database backup for restoration (Using SQL BackTrack
dryrun facility)



Monthly - update index statistics on all tables



"Frank" <soal6570@yahoo.com> wrote in message
news:42601b2.0404150321.71ffdac9@posting.google.co m...
> Thanks Willie, That's a good one but doesn't over all. Seems there is
> not too many good Sybase web sites there. Any other suggestion?
> What's the best advanced technical dba bood for 12.5?
>
> "Willie Kraatz" <wkraatz@csc.com> wrote in message
news:<c5jc4p$l7j$1@lore.csc.com>...
> > Check out the The Boss Sybase DBA page at
> > http://www.bossconsulting.com/sybase_dba/
> > Rob Verschoor's site at http://www.sypron.nl/download.html
> > Kevi Sherlock's site at http://teamsybase.com/kevin.sherlock/
> > "Frank" <soal6570@yahoo.com> wrote in message
> > news:42601b2.0404131900.27a8c76@posting.google.com ...
> > > I am taking responsible for a Sybase 12.5 DB on HP-UX 11i and I am
> > > pretty much in Sybase specially in UNix env. Please give me some
> > > initial things that I have to check, for example
> > >
> > > Check ENV vatiables
> > > where is the Server logs?
> > > Ps - ef | grep ???
> > > Server status , health check??
> > > select @@version
> > > crontab -l
> > > backup? they run sqlbacktrack also!
> > > ?
> > > ?
> > >
> > >
> > >
> > > Please give me some better guideline, some more commands to check and
> > > if you have an organized doc for a new dba env I greatly appreciate
> > > your help.