处理大量数据的最佳实践 [英] Best Practices on Processing Large Amounts of data

问题描述

我们也遇到类似的情况...

我们正在运行带有sql 2008 enterprise的server 2003 r2 x64，带有12gb RAM和1个双核处理器(单端口计算机)

我们正在运行一个使用10.7gb页面文件的非常重的重复数据删除查询.我们需要运行其中的几个查询，但是当我们执行多个查询时，性能会受到严重影响.当仅运行一个查询但 当我们执行第二/第三次查询(页面文件使用率保持在10.7gb)时，命中率达到90％以上

We are running server 2003 r2 x64 with sql 2008 enterprise with 12gb RAM and 1 dual core processor (singe port machine)

We are running a really heavy deduping query which is using 10.7gb pagefile. We need to run several of these queries but performance suffers very badly when we execute more than one. CPU usage is fairly static at less then 10% when only one query running but shoots to 90% + when we execute second/ third queries (pagefile usage stays at 10.7gb)

我们没有使用UI.数据本地存储在dbo中.

我们需要提高性能，问题是我们需要更多的RAM还是切换到四核处理器?

We are not using a UI.  Data is stored locally on dbo.

We need to improve performance, the question is do we get more RAM or switch to a quad core processor?

推荐答案

你好，

        谢谢您的发帖！我建议在(  Windows Server论坛 > 常规  )位于此处的论坛: ( http://social.technet.microsoft.com/Forums/zh-CN/winservergen/threads ).

          Thank you for your post!  I would suggest creating a new thread for your question in the ( Windows Server TechCenter > Windows Server Forums > General  ) forum located here:  ( http://social.technet.microsoft.com/Forums/en/winservergen/threads).

       希望对您有所帮助.

         Hope that would be helpful.

       祝你有美好的一天！

         Have a great day!

      谢谢&问候

        Thanks & regards,

这篇关于处理大量数据的最佳实践的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！