WINDOWS 2008 SERVER 安装SQL SERVER 内存使用15.5G

我的服务器是WINDOWS 2008 SERVER 64BIT
安装了 SQL SERVER 数据库，分析服务，报表服务。现在内存使用了15.5G
我通过任务管理器看到使用内存最多的进程才使用了400M啊。为何这样多啊。
从哪里下手取查看这个问题？
谢谢！

解决方案 »

  1.   

    设置SQL使用的最大内存，重启服务就可以了
      

  2.   

    在使用的
    "(PDH-CSV 4.0) (","\\CDC-DW-01\Memory\Available MBytes","\\CDC-DW-01\Memory\Pages/sec","\\CDC-DW-01\Memory\Available Bytes","\\CDC-DW-01\Memory\Committed Bytes","\\CDC-DW-01\Memory\Pages Input/sec","\\CDC-DW-01\Memory\Pages Output/sec"
    "02/22/2011 10:30:17.569","207","0","217128960","17866797056","0","0"
    "02/22/2011 10:30:32.570","206","0","216305664","17867046912","0","0"
    "02/22/2011 10:30:47.570","207","1.133411436785329","217935872","17865195520","1.133411436785329","0"
    "02/22/2011 10:31:02.569","207","0","217890816","17864970240","0","0"
    "02/22/2011 10:31:17.570","211","0","221261824","17862164480","0","0"