|
我有一个SQL Server 2008(版本10.0.1600)在
Windows Server 2008 R2企业版处事器上运行,具有8 GB的物理内存.假如我打开使命打点器,我可以在“机能”选项卡的“物理内存”部门看到只有340 MB可用的8191总计,但我看不到任何行使这种内存量的历程.请留意SQL Server的内存限定为6GB(最大处事器内存= 6000).
假如我打开Sysinternals Process Explorer,我可以看到sqlsrvr.exe历程有：
Private Bytes: 227.000 K
Working Set: 140.000 K
Virtual Size: 8.762.000 K
这意味着什么？有没有步伐为其他历程开释这些内存？为什么假造巨细数字为已分派内存？我以为Virtual Size只是’保存影象’.
办理要领
这个是正常的. SQL处事器将始终行使全部可用内存,并在体系必要更多资源时缩减.
THIS文章描写了产生了什么.
When you start SQL Server,SQL Server memory usage may continue to steadily increase and not decrease,even when activity on the server is low. Additionally,the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.
This behavior alone does not indicate a memory leak. This behavior is normal and is an intended behavior of the SQL Server buffer pool.
By default,SQL Server dynamically grows and shrinks the size of its buffer pool (cache) depending on the physical memory load reported by the operating system. As long as enough memory is available to prevent paging (between 4 – 10 MB),the SQL Server buffer pool will continue to grow. As other processes on the same computer as SQL Server allocate memory,the SQL Server buffer manager will release memory as needed. SQL Server can free and acquire several megabytes of memory each second,allowing it to quickly adjust to memory allocation changes.
（编辑：湖南网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
