?
Solved

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

Posted on 2013-06-23
3
Medium Priority
?
3,957 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 26

Accepted Solution

by:
wilcoxon earned 1200 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 400 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 400 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

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