Results 1 to 4 of 4

Thread: Sybase Details

  1. #1
    Join Date
    Nov 2006
    Posts
    34

    Question Unanswered: Sybase Details

    Hi ALL,
    I have to find the perfomance of the Sybase so i want the details of Lock,Latch,Buffer,Network I/O and memory Utilization.Is there any system tables or system procedure to find all these details.

    Also i ahve tried sp_sysmon and montables .So please leave these two and just let me know any other tables or procedures to find these details.

    Thanks,
    Arun

  2. #2
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Well if you have already tried sp_sysmon & MDA tables, and that does not satisfy you, you must have some very special needs, so post them.

    For heavy-duty low-intrusion server-based monitoring refer to Monitor Server.

    For light client-based monitoring, Bradmark Surveillance is the best in its class.

    Cheers
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  3. #3
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    No.

    This information is in Sybase ASE Memory and counters [1], it is not provided in tables. This information is readily and easily reported via sp_sysmon (that is its purpose in life). It is very good, and most P&T consultants use it as the main monitoring tool. Zero overhead, zero set up. What is the problem with using it ?

    For MORE details than sp_sysmon provides, plus diagnostic (ie. on top of monitoring) info, use MDA tables. But this is labour-intensive to set up and configure the way you want it, and it has overhead.

    If you are writing a serious performance monitoring app, then use Sybase Monitor Client. This allows you to access Sybase memory [1] directly and has virtually no OH. That's what the third party performance monitoring tools use.

    Cheers
    Last edited by DerekA; 11-23-06 at 03:38.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  4. #4
    Join Date
    Nov 2006
    Posts
    34

    Sybase Details

    Hi,
    Thanks for the info.But i want to retrieve this info using java but sp_sysmon didnt return resultset so i drop the idea of using it.About MDA tables becoz of labour-intensive to set up so i drop it .

    Is any way to retrieve all the info i need.????????

    Also i saw a sp_monitorconfig is it right procedure to check the memory utilization?or it just a configuration setup.pls help


    Thanx n advance
    Arun

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •