Hi Sybase DBAs please help an Oracle DBA

[farrokhp]

I come from Oracle DBA background and I know a little about SQL server
and Sybase ceneral. In a Production Sybase environnmet:

1- How do you create a baseline for performance tuning?

2- How do you refresh Dev box from a large Production DB?

3- what's the few main scripts you schedule or use everyday in sybase?

4- what's the main unix commnads to startup, shoudown and check the
sybase DB?


5- What's the main sp_ procs you use everyday?


6- How do you find and tune top 10 bad sqls?

7- what's the best forums to post questions and get quick answers?


8- what's the best 3 third party tools for sybase?

9- any sybase - oracle equivalent cheat sheet exist in internet or
book?

10- what's the top 3 books you recommended?


Many thanks for your time and reply.

 

[Tison]

You ask too much.Try 1 thing at a time.

 

[Zahier]

Hi Farrohk,

I too am new to Sybase, being an ex Oracle DBA myself.
I use these URL's for support:

http://www.sypron.nl/download.html

http://manuals.sybase.com/onlinebooks/group-iqarc/iqg1200e/;pt=35370

http://sybooks.sybase.com/onlinebooks/group-as/asg1200e/;pt=4251

SO far have only put in scripts check space usage:
sp_iqstatus (for sybase iq)
sp_helpdb (sybase ASE)

Im using DBArtisan and Syabse Central for 3rd party admin.

I wish you well.
Zahier