这个server的内存配置正常吗?
$ isql -Usa -w150Password:
1> sp_configure mem
2> go
Msg 17411, Level 16, State 1:
Server 'test', Procedure 'sp_configure', Line 322:
Configuration option is not unique.
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ -------------------- ----------- -------------------- -------------------- -------------------- ----------
additional network memory 0 0 0 0 bytes dynamic
allocate max shared memory 0 0 0 0 switch dynamic
compression memory size 0 152 0 0 memory pages(2k) dynamic
enable query tuning mem limit 1 0 1 1 switch dynamic
engine memory log size 0 2 0 0 memory pages(2k) dynamic
heap memory per user 4096 0 4096 4096 bytes dynamic
lock shared memory 0 0 0 0 switch static
max memory 63488 32768000 16384000 16384000 memory pages(2k) dynamic
memory alignment boundary 16384 0 16384 16384 bytes static
memory per worker process 1024 4 1024 1024 bytes dynamic
messaging memory 400 0 400 400 memory pages(2k) dynamic
pci memory size 32768 0 32768 32768 memory pages(2k) dynamic
shared memory starting address 0 0 0 0 not applicable static
total logical memory 63488 30883556 15441778 15441782 memory pages(2k) read-only
total physical memory 0 30883556 0 15441778 memory pages(2k) read-only
(1 row affected)
(return status = 1)
Memory Used 和Run Value是什么值啊?怎么理解 ? run value是指你给他配置的,使用sp_configure "max mem",配置的数值
max mem的话就是16384000个page,后面也有解释是memory pages(2k),因此 Memory Used 是pagex2K,就是32768000
另外说一句,不管服务器页面是2,4,8或者16,这种配置值是页面大小的想要算具体内存的使用量都是x2K/page
页:
[1]