一个新服务器的SQL Server tempdb优化提示？ [英] SQL Server tempdb optimization tips for a new server?

问题描述

我计划在新计算机上全新安装 SQL Server 2005 ，我必须订购。我知道 tempdb调整对于SQL Server实例的整体效果非常重要。

I am planning a fresh installation of SQL Server 2005 on a new machine, which I have to order. I know that tempdb tuning is very important to the overall performance of the SQL Server instance.

阅读它的最佳实践是创建尽可能多的tempdb文件，你有CPU（或核心？）。那是对的吗？是否有任何其他建议，例如硬盘/ RAID设置配置我应该注意？

I've read that it's best practice to create as many tempdb files as you have CPU's (or cores?). Is that correct? Are there any other recommendations, e.g. for harddisk/RAID setup configuration I should pay attention to?

感谢！

推荐答案

如果我不得不选择一个我信任的人配置服务器的建议，这将是丹尼樱桃。他写了一篇文章解释这个问题。

If I had to pick one person that I trust for advice on configuring a server, it would be Denny Cherry. He wrote an article explaining this.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1307255,00.html

这篇关于一个新服务器的SQL Server tempdb优化提示？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！