Solved

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

Posted on 2013-06-23
3
2,806 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ODBC connection for Raiser's Edge 6 --SqlAnywher 5.0 8 809
SQL Substring Extraction 4 546
Clean up a mailbox 5 153
Why did SAP buy Sybase? 3 155
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
An analysis of the phishing scam that has been affecting Google users, along with steps to take for protection, as well as what to do if you receive one of the emails.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now