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.

On Sat, 03 Apr 2004 08:25:04 -0800, Frank wrote:

Assuming the dev box has the same database layout, dump the production db
and load it to the dev box.


database and transaction dumps.


$SYBASE/$SYBASE_ASE/install/startserver to start the server.
"shutdown" SQL command.
dbcc checks (SQL commands)

sp_who, sp_help, sp_lock, probably others. I tend to use ad-hoc procs as
well.

Here, and news://forums.sybase.com/

--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

Thanks a lot for answers. It was great specially the link you sent me.
Just few more questions:

1- What is the best practice for sizing a new Database and
configuration parameters? Any link for that or just a quick comment
from you? Do we have something like init.ora here?

2- I heard that you can write custom-scripts for admin and put them in
master database and access them for all db. Is that the way you can
cutom monitor the db? Can you send me a small example?


3- What is the top 5 troubleshooting and monitoring needs to be done
as a daily basis?



Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote

"Frank" <soal6570 (AT) yahoo (DOT) com> wrote

This cannot easily be answered in a few lines since this is more about a
methodology than a product feature...

Make a database dump in production and load it on development. Make sure
your dev.database has at least the size of your production database or you
cannot load the dump -- for example, when your prod. db is 1Gb in size and
only 100 Mb full, your dev.db must still be >= 1Gb.
Before you ask: no, databases cannot easily be shrunk except by copying the
data out to files, recreating the database and copying the data back in.
THis feature is high on everyone's list...

- making database dumps and transaction log dumps
- running update statistics
- running dbcc checks
- checking the ASE errorlog for error messages

The frequency of these actions can vary though. dbcc checks are typically
run once a week, not necessarily every night

startserver -f RUN_YOURSERVERNAME (the file 'RUN_YOURSERVERNAME' is
typically located in $SYBASE/$SYBASE_ASE/install)

There are lots... I guess sp_helpdb, sp_who are the most common ones

If you're on 12.5.0.3, have a look at the monitoring tables
(www.sypron.nl/mda)

Best go to the sybase.public.ase.* newsgroups at formus.sybase.com (Sybase's
own news server)


Difficult... it's a matter of taste. DBArtisan is quite nice for everyday
use.

There are some Sybase- Ora comparisons around. See the links at
www.sypron.nl/syblinks.html


First, check out the free documentation by Sybase -- they're pretty good.
See www.sypron.nl/get_ase_docs.html for some pointers.
You may want to have a look at two ASE books I've published -- see
www.sypron.nl/qr and www.sypron.nl/ttr.



HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------