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...
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...
what's the eqivalant of main Oracle DBA tasks in sybase?
how do you find top 10 bad sql and tune it?
how do you refresh a VLDB devlopnet DB from Production DB?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.