What is difference between Virtual Memory size ,Real Memory Size and Database size in Disk in case of Sybase SQL Anywhere 12 and how to calculate it ? are there any commands or utilities to calculate it ?

asked 06 Jan '21, 05:36

jagdish's gravatar image

jagdish
41115
accept rate: 0%


Virtual Memory size is the amount of "address space" in use by the process. See https://en.wikipedia.org/wiki/Virtual_address_space. It's effectively just memory address ranges that are allocated but don't necessarily take up any physical RAM.

Real Memory size refers to resident memory size (or resident set size). This is the actual amount of physical RAM being used by the process.

Database Size on Disk refers to the sum of the size of all dbspaces including the temporary dbspace but not the transaction log.

Tools will depend on OS. Beware the task manager for Windows which, IIRC, shows values like "Memory Size" and doesn't tell you exactly what it means. Perfmon on Windows was much clearer about the various memory metrics. For Linux, there are countless tools (top, /proc contents, ps, ...). Google for other tools Windows, Linux or whatever OS you are using.

permanent link

answered 06 Jan '21, 07:33

John%20Smirnios's gravatar image

John Smirnios
11.9k396165
accept rate: 37%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×28
×15
×3

question asked: 06 Jan '21, 05:36

question was seen: 1,334 times

last updated: 06 Jan '21, 07:33