SQL SERVER 2008 - 存储数百万条记录时出现内存泄漏
我非常需要一些帮助.我正在从事一个始终输入大量数据的项目.这是一个报告软件.
I need some help very badly. I'm working on a project where a bulk of data is entered all the time. It's a reporting software.
平均每天存储 1000 万条记录，而且随着用户的增加，它还会继续增加.
10 Million records in an average is stored per day and it could keep on increasing as users increase.
截至目前，SQL SERVER 在任务管理器上消耗 5gb 的 RAM.我的服务器上现在有一个 8GB 内存.
As of now, SQL SERVER CONSUMES 5gb of RAM on the task manager. I have an 8GB ram on my server now.
其他企业如何应对这种情况?
How do other enterprises manage such situations?
推荐答案
SQL Server 有效地使用内存并尽可能多地占用.它通常也足够聪明，可以在需要时释放内存.
SQL Server uses memory efficiently and takes as much as it can. It's also usually clever enough to release memory when needed.
使用 5GB 意味着:
Using 5GB means:
- SQL Server 配置为 5GB 或 SQL Server 只是在正常使用期间保留了此内存
- 还剩 3GB 因为它不需要使用它
没有错...我可能会将 SQL Server 最大内存配置为 6.5GB...
Nothing is wrong... and I'd probably configure the SQL Server max mem to 6.5GB...
后期补充:Jonathan Kehayias 博客条目
相关文章