can any one please tell me the isql commends for monitor Sybase ASE database

[t_ashok_reddy_t]

can any one please tell me the isql/os commends for monitor Sybase ASE database

i dont have sybase scc and dbacockpit

1) data used in disk

2) log used in disk

3) memory usage like (used memory peak memory, physical on host, all process memory, )

4) CPU status like (cpu process, cpu host)

5) disk usage like (disk usage data volume, disk usage log volume, disk usage space for backup)

6) Backups (Backup Data, backup log backup)

7) Lock Manager (Lock Waits, Max. Wait Time, Deadlocks*, Lock Timeouts*, Table Lock Spins*, Row/Pg. Lock 😎 Spins*,

😎 Address Lock Sp

[Johan_sapbasis]

Hi,

Also basic command to get basic overview.

sp_monitorconfig 'all'

Johan

[Former Member]

Ashok,

It sounds like you need to buy the Jeff Garbus book for SAP ASE 16.

99.9% of it will apply to ASE 15.7.

SAP ASE 16 / Sybase ASE Administration. of Jeffrey Garbus - by SAP PRESS

*** Use these at your own risk ***

1. sp_helpdb dbname

2. See #1

3. sp_cacheconfig shows memory divided by cache -- 

4. sp_sysmon -- see manual before use

5. sp_helpdevice devicename

6. Backups -- See backupserver logs

7. See #4

8. See #4

If someone gives a complete or helpful answer, please note that reply.

[Johan_sapbasis]

Hi Cory,

I actually have a copy off the Jeff Garbus book but it is written and directored more at an experienced DBA than a Basis consultant, due to it being very low level more detailed than what is needed for basis work.

At least this is my experience I have only been working on sybase for 5 months now, but best information I have gathered is from sap notes and the infocenter pages and documentation.

I do still occasionally reference the book but my 2cents worth if you are only a basis consultant not permanently engaged on sybase I think you are better of just using these other sources of information.

That having been said there is also very little sybase information out there, and at least here in south africa I have also not seen course offerings , but I am now deviating from the original post.

Johan

[crisnormand]

Dear Ashok,

Your previous thread has been moved to SAP Adaptive Server Enterprise (SAP ASE) for Custom Applications: http://scn.sap.com/thread/3777339 The reason is that SUP/SMP is not part of the Business Suite. You may want to check if the suggestion I provided there is helpful for your request.

Regards,

Cris

[t_ashok_reddy_t]

then where do i post my query ?? even SUP/SMP with SAP ASE