这个server的内存配置正常吗?
时间:2010-09-20
来源:互联网
$ isql -Usa -w150
Password:
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 是什么值啊?怎么理解 ?
Password:
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 是什么值啊?怎么理解 ?
作者: piml_lv 发布时间: 2010-09-20
run value是指你给他配置的,使用sp_configure "max mem",配置的数值
max mem的话就是16384000个page,后面也有解释是memory pages(2k),因此 Memory Used 是pagex2K,就是32768000
另外说一句,不管服务器页面是2,4,8或者16,这种配置值是页面大小的想要算具体内存的使用量都是x2K/page
max mem的话就是16384000个page,后面也有解释是memory pages(2k),因此 Memory Used 是pagex2K,就是32768000
另外说一句,不管服务器页面是2,4,8或者16,这种配置值是页面大小的想要算具体内存的使用量都是x2K/page
作者: D_D_D_D 发布时间: 2010-09-20
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28