Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4456
  • Last Modified:

Sybase How do we check ASE memory in MB or Gb ?

I have following configuration for sp_configure 'max memory' how do I know what size in MB/GB the memory have been allocated for this instance ?


ASE memory
0
motioneye
Asked:
motioneye
3 Solutions
 
wilcoxonCommented:
Max memory shows it is in "memory pages (2k)" units so the amount in MB/GB would be:
104,000,000 * 2048 = 212,992,000,000 B / (1024 * 1024) = 203,125 MB / 1024 = 198.36 GB

The above assumes Sybase uses 1024 = 1kb.  Some (math-deficient) systems use 1000 = 1kb (which would change the * 2048 to * 2000 in the first step).
0
 
Joe WoodhousePrincipal ConsultantCommented:
sp_configure reports its units for each configurable parameter. I don't think it's possible to change the units that it uses, although you could take a look at its source code (it's in sybsystemprocs, use sp_helptext on it) to write your own that used MB or GB for some items.

That said, maybe sp_helpconfig has some of what you need? You can use it to ask "how much memory would setting this parameter to this value cost me?", and "how many locks would fit in 1MB of memory?".
0
 
alpmoonCommented:
I agree with Joe. The unit is always 2k for memory configuration parameters and actually "memory used" always report used memory as KB. So allocated memory is ~99 GB.

You can confirm it by using top utility on UNIX.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now