Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    61

    Unanswered: SQL to monitore performance...

    Hello..

    My database's very slow... I'd like know if there are some sql to know what process's more slow..... and what is getting more memory...


    Thanks..
    Fernando.

  2. #2
    Join Date
    Oct 2007
    Posts
    61
    I ran the sql.... and see that my phylog percent free's just in 2 percent..

    It's bad to my database ?


    select name[1,8] dbspace, -- name truncated to fit on one line
    sum(chksize) Pages_size, -- sum of all chunks size pages
    sum(chksize) - sum(nfree) Pages_used,
    sum(nfree) Pages_free, -- sum of all chunks free pages
    round ((sum(nfree)) / (sum(chksize)) * 100, 2) percent_free
    from sysdbspaces d, syschunks c
    where d.dbsnum = c.dbsnum
    group by 1
    order by 1;



    dbspace percent free
    loglog 18.99
    phylog 2.23
    prddbs 26.10
    prdtmp1 99.45
    prdtmp2 99.48
    rootdbs 84.44

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    I suggets that run update statistics for all database, next run:
    set explain on avoide_execute;
    SELECT ..........

    Then verify performance.

    Gustavo.

  4. #4
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    onstat -g ses
    onstat -g mem
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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