Hi,
I am learning Sybase, my PM asked me the following question, Please
help me on this :
You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase
Database Server is performing very badly for about a week now and that
immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
Please give me ur step-by-step level to proceed for the above
scenario.
Thanks in Advance.
With Regards,
Raja.
Jonathan Leffler - 27 Sep 2008 07:17 GMT
> I am learning Sybase, my PM asked me the following question, Please
> help me on this :
[quoted text clipped - 10 lines]
> Please explain things in a high level along with assumptions and
> recommendations.
s/Sybase/Oracle/g - and the same question was asked in
comp.databases.oracle.server.
s/Sybase/DB2/g - and the same question was asked in comp.databases.ibm-db2
Methinks Raja is learning a lot of DBMS all at once.

Signature
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/
publictimestamp.org/ptb/PTB-4326 whirlpool0 2008-09-27 06:00:06
E61A0DAD8E6326EDAD4E2B40680177A8DDBF21D099A7557F3D326861F55ECA137676F3
CC89D63BA236FFCE9E9026CEFBE4AC2A987F5872ECDB3AF22034AA449
Sybaseguru - 02 Oct 2008 21:47 GMT
>> I am learning Sybase, my PM asked me the following question, Please
>> help me on this :
>
> Methinks Raja is learning a lot of DBMS all at once.
Sounds like it. The interesting thing is that the answer is the same!