What means for 'memory used' in sp_configure output?

[Former Member]

I use sp_configure 'max memory' and got the result:

1> sp_configure 'max memory'

2> go

Parameter Name                 Default     Memory Used Config Value

         Run Value   Unit                 Type

------------------------------ ----------- ----------- ------------

         ----------- -------------------- ----------

max memory                           45056     8000000     4000000

             4000000 memory pages(2k)     dynamic

(1 row affected)

(return status = 0)

the max memory is configured as 4000000( roughly 7.6G). but there is one 'Memory Used' is 8000000. what' it? it is double of 'max memory' value and run value.  it's 15G memory used?

[Mark_A_Parsons · Accepted solution]

Unless stated otherwise 'used memory' is the number of KB.

In this example you have 400,000 x 2KB pages defined for max memory, which is the same as 'memory used' = 800,000 KB.

[former_member188883]

Hi Kent,

Further to add,

you should look at how much 'max memory' is allocated by running sp_configure and how much 'logical memory' is showing which is the amount of memory that ASE can demand upto with the configured parameters. Also, if you do just sp_configure 'memory', at the end, you can see how much free memory is left that can be still used for other resources.

Mutiply the value under "configured value" by 2 to get the max allocated value.

Hope this helps.

Regards,

Deepak Kori