当前位置: 代码迷 >> Sql Server >> sql server 2008 内存有关问题
  详细解决方案

sql server 2008 内存有关问题

热度:28   发布时间:2016-04-24 10:35:03.0
sql server 2008 内存问题
       最近服务器不稳定总崩溃,查看数据库日志时发现如下信息,看不太明白还请大神们帮忙分析下原因,是否数据库服务器内存不够了,ms sql 2008数据库服务器是一台虚拟机内存8G,物理机内存16G(物理机上没装东西),物理机上还有一台虚拟机内存4G。ps:系统最近更新了一个功能,会访问一个大约2千万条记录的表,不知道问题是不是出在这?(非常着急,在线等)


2014-05-08 18:28:45.29 spid162     
Memory Manager                                   KB
---------------------------------------- ----------
VM Reserved                                 1690680
VM Committed                                1689096
AWE Allocated                                     0
Reserved Memory                                1024
Reserved Memory In Use                            0
2014-05-08 18:28:45.29 spid162     
Memory node Id = 0                               KB
---------------------------------------- ----------
VM Reserved                                 1687864
VM Committed                                1686392
AWE Allocated                                     0
MultiPage Allocator                           17680
SinglePage Allocator                         878408
2014-05-08 18:28:45.29 spid162     
Memory node Id = 32                              KB
---------------------------------------- ----------
VM Reserved                                    1728
VM Committed                                   1672
AWE Allocated                                     0
MultiPage Allocator                            1600
SinglePage Allocator                         878408
2014-05-08 18:28:45.29 spid162     
MEMORYCLERK_SQLGENERAL (node 0)                  KB
---------------------------------------- ----------
VM Reserved                                       0
VM Committed                                      0
AWE Allocated                                     0
SM Reserved                                       0
  相关解决方案