cancel
Showing results for 
Search instead for 
Did you mean: 

difference between Virtual Memory size ,Real Memory Size and Database size in Disk

1,772

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 ?

Accepted Solutions (0)

Answers (1)

Answers (1)

johnsmirnios
Employee
Employee

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.