vmstat question
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: vmstat question

  1. #1
    Join Date
    Dec 2000
    Posts
    87

    Angry

    Hi all,

    Would someone please to me the following output, is the server healthy? If there is a problem, can someone please identify it/them, thanks a lot.

    By the way, what does column 'w' actually mean? From Solaris's man page, it says 'runnable but swapped'...But I still don't get it, what's been swapped? Memory or else? Or there is other explanation. Thanks.

    procs memory page disk faults cpu
    r b w swap free si so pi po fr de sr m0 m1 m1 m1 in sy cs us sy id
    1 3 0 4043960 210024 0 0 91 1 0 0 0 0 8 5 5 1000 1039 570 50 2 49
    0 4 0 4048304 77376 0 0 121 0 0 0 0 0 0 0 0 1086 842 678 36 3 62
    0 5 0 4048272 77152 0 0 145 0 0 0 0 0 0 0 0 1110 5885 693 35 3 62
    0 4 0 4048392 77416 0 0 112 3 3 0 0 0 0 0 0 940 678 591 28 2 70
    0 3 0 4048552 77320 0 0 107 0 0 0 0 0 0 0 0 826 525 528 34 2 64
    0 4 0 4048560 77216 0 0 147 0 0 0 0 0 0 0 0 896 686 593 43 2 55
    0 3 0 4048528 77656 0 0 142 0 0 0 0 0 0 0 0 858 637 578 35 2 63
    0 3 0 4048552 77624 0 0 99 0 0 0 0 0 1 1 1 924 827 590 59 2 39

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I am not a Solaris expert but what I know about VMSTAT is that FREE should not be so low (it is like 70M). PI (Page In) and PO (Pages Out) is OK, it should be close to 0 bur ID, the last column should be in the high 90s. It isn't in your case.

  3. #3
    Join Date
    Dec 2000
    Posts
    87

    Angry

    Thanks Julian. However, it's still not clear to me, I need a more in-deepth explanation.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    From what I see, the feeling is that you either need more RAM or you need to reduce the size of the SGA.


  5. #5
    Join Date
    Dec 2000
    Posts
    87
    Can you please explain according to what information made you think that.

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    You have only about 70M free! That's not much at all.


  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    vmstat output alone is not enough information to determine if you need to add more RAM.
    How much swap do you have and how much is used?
    How much physical RAM do you have on the box?
    How much does your SGA occupy?
    How many CPU's do you have?
    What are your top 10 processes?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Jeff, doesn't 70M FREE mean that there are about 70M of unused RAM (at the moment)?


  9. #9
    Join Date
    Dec 2000
    Posts
    87

    Angry

    I know there are a lot more information that I need to supply before determining what's actually needed.

    However, can you or someone please
    1. What does column 'w' presents, from Solaris man page,
    it says 'swapped but runnable', but what does it mean? What's been swapped? Memory?

    2. Make comments on the output, just as if someone as you in the interview 'What can you see from the output of each column?'

    Thanks a lot.

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    However, can you or someone please
    1. What does column 'w' presents, from Solaris man page,
    it says 'swapped but runnable', but what does it mean? What's been swapped? Memory?
    'w' shows the number of processes that are able to run but which are swpped out. Swapping is the movement of active processes of memory to disk. It is more dangerous than paging. Paging means the movement of inactive processes of memory to disk.


Posting Permissions

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



Click Here to Expand Forum to Full Width