SQL SERVER 2008-存储数百万条记录时发生内存泄漏 [英] SQL SERVER 2008 - Memory Leak while storing Millions of records
问题描述
我非常需要一些帮助. 我正在一个项目中，一直在输入大量数据.这是一个报告软件.
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意味着:
- 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...
最新添加: 查看全文
