Solved

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

Posted on 2013-06-23
3
2,967 Views
Last Modified: 2013-07-15
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
Comment
Question by:motioneye
3 Comments
 
LVL 26

Accepted Solution

by:
wilcoxon earned 300 total points
ID: 39269995
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
 
LVL 24

Assisted Solution

by:Joe Woodhouse
Joe Woodhouse earned 100 total points
ID: 39270867
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
 
LVL 13

Assisted Solution

by:alpmoon
alpmoon earned 100 total points
ID: 39273552
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the biggest threats in the cyber realm pertains to advanced persistent threats (APTs). This paper is a compare and contrast of Russian and Chinese APT's.
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question