Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76

    Unhappy Unanswered: How to read sp_sysmon report

    HI,guys:
    I did sysmon and got the output report.
    Can someone help how to read the report and find performance bottleneck.
    Kenerl
    ================================================== =============================
    Sybase Adaptive Server Enterprise System Performance Report
    ================================================== =============================

    Server Version: Adaptive Server Enterprise/11.9.2.2/P/SWR 8944 ESD 2/Lin
    Server Name: Server is Unnamed
    Run Date: Dec 29, 2004
    Statistics Cleared at: 11:21:10
    Statistics Sampled at: 11:31:21
    Sample Interval: 00:10:10

    ================================================== =============================

    Kernel Utilization
    ------------------

    Engine Busy Utilization
    Engine 0 55.4 %
    Engine 1 96.2 %
    ----------- --------------- ----------------
    Summary Total 151.6 % Average 75.8 %

    CPU Yields by Engine per sec per xact count % of total
    ------------------------- ------------ ------------ ---------- ----------
    Total CPU Yields 0.0 0.0 0 n/a

    Network Checks
    Non-Blocking 10519.2 21751.5 6416686 99.4 %
    Blocking 67.1 138.7 40913 0.6 %
    ------------------------- ------------ ------------ ----------
    Total Network I/O Checks 10586.2 21890.2 6457599
    Avg Net I/Os per Check n/a n/a 0.00544 n/a

    Disk I/O Checks
    Total Disk I/O Checks 12899.5 26673.6 7868725 n/a
    Checks Returning I/O 0.0 0.0 0 0.0 %

    ================================================== =============================
    I mentioned network blocking statisics is not zero,Does it mean there exists network problems?

  2. #2
    Join Date
    Sep 2004
    Location
    Stockholm, Sweden
    Posts
    28
    This is just a small piece of the sysmon report. You really should read the "Performance and tuning guide", chapter "monitoring performance with sp_sysmon".

    http://manuals.sybase.com/onlinebook...eric__BookView

    /Mats

  3. #3
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76

    Smile

    thanks of matssve's reply

Posting Permissions

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