Sybase memory in corresponds to sybase pagesize
I have setup Sybase to use @@maxpagesize 4096, then I just want to confirm the command and formula I used below are correct to convert the value of memory to MB ?
Another strange is our Linux VM is running with 1.8GB memory, I just come across that configure memory is bigger than memory allocated to the VM ?
and the Memory_used is around 6GB ( 3072000 pages ) which we only have 1.8GB memory in Linux VM
Another strange is our Linux VM is running with 1.8GB memory, I just come across that configure memory is bigger than memory allocated to the VM ?
and the Memory_used is around 6GB ( 3072000 pages ) which we only have 1.8GB memory in Linux VM
> select @@pagesize
2>
-----------
2048
(1 row affected)
1> select @@maxpagesize
2>
-----------
4096
(1 row affected)
1> sp_configure 'memory'
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------------------------------------ ---------------------------------------- ---------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- --------------------
additional network memory 0 0 0 0 bytes dynamic
allocate max shared memory 0 0 0 0 switch dynamic
compression memory size 0 152 0 0 memory pages(2k) dynamic
engine memory log size 0 2 0 0 memory pages(2k) dynamic
heap memory per user 4096 1421312 4096 4096 bytes dynamic
kernel resource memory 4096 8344 4096 4096 memory pages(2k) dynamic
lock shared memory 0 0 0 0 switch static
max memory 98304 3072000 1536000 1536000 memory pages(2k) dynamic
memory alignment boundary 4096 0 4096 4096 bytes static
memory dump compression level 0 0 0 0 number dynamic
memory per worker process 1024 4 1024 1024 bytes dynamic
messaging memory 400 0 400 400 memory pages(2k) dynamic
pci memory size 32768 0 32768 32768 memory pages(2k) dynamic
replication agent memory size 4096 8194 4096 4096 memory pages(2k) dynamic
shared memory starting address 0 0 0 0 number static
total logical memory 98304 229954 114973 114977 memory pages(2k) read-only
total physical memory 0 229948 0 114974 memory pages(2k) read-only
transfer utility memory size 4096 8194 4096 4096 memory pages(2k) dynamic
(1 row affected)
An additional 2842046 K bytes of memory is available for reconfiguration. This is the difference between 'max memory' and 'total logical memory'.
(return status = 1)
1> select 2842046/1024
2>
-----------
2775
(1 row affected)
1> select 1536000*2/1024
2>
-----------
3000
(1 row affected)
1> select 114973*2/1024
2>
-----------
224
(1 row affected)
1> SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER