Max Memory

gopalmpawar · #1 (**permalink**) 06-24-11, 04:19

How to see max memory of ASE from UNIX command prompt?

Martijnvs · #2 (**permalink**) 06-24-11, 07:32

Log in to the databaseinstance with isql, and execture sp_configure "max memory".

gopalmpawar · #3 (**permalink**) 06-24-11, 07:45

Log in to the databaseinstance with isql, and execture sp_configure "max memory".

Not from isql, can we see from UNIX o.s command promp?

Martijnvs · #4 (**permalink**) 06-27-11, 03:17

Technically speaking, you can open an isql-session from the UNIX-prompt, but I gather you don't have access to the db-instance?
There is a .cfg-file located in $SYBASE that contains a block [Physical Memory], with a row Max Memory. That values is either DEFAULT, or some altered value.