Performance tuning SQL Server 2005 (and other editions)http://blogs.msdn.com/darien/archive/2006/05/29/610044.aspxSo here's an all too common question about SQL Server performance tuning. How do I tune the overall server performance using "Priority Boost" or "Affinity Mask" or [insert system parameter here] . And you know what? The product group actually designeden-USCommunityServer 2.1 SP1 (Build: 61025.2)Interesting Finds: May 29, 2006 AM editionhttp://blogs.msdn.com/darien/archive/2006/05/29/610044.aspx#610101Mon, 29 May 2006 17:24:48 GMT91d46819-8472-40ad-a661-2c78acb4018c:610101Jason HaleyTroubleshooting Performance Problems in SQL Server 2005... a follow uphttp://blogs.msdn.com/darien/archive/2006/05/29/610044.aspx#616654Sun, 04 Jun 2006 10:51:21 GMT91d46819-8472-40ad-a661-2c78acb4018c:616654Darien's Dialog..Thank you for all the feedback on Performance tuning SQL Server 2005 (and other editions). Honestly,...re: Performance tuning SQL Server 2005 (and other editions)http://blogs.msdn.com/darien/archive/2006/05/29/610044.aspx#3916891Tue, 17 Jul 2007 17:14:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:3916891Antonis<p>Nice!</p>re: Performance tuning SQL Server 2005 (and other editions)http://blogs.msdn.com/darien/archive/2006/05/29/610044.aspx#3926840Wed, 18 Jul 2007 03:10:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:3926840Theodosios<p>Cool!</p>re: Performance tuning SQL Server 2005 (and other editions)http://blogs.msdn.com/darien/archive/2006/05/29/610044.aspx#9624584Mon, 18 May 2009 01:55:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:9624584Pamela Brubaker<p>Thanks, nice description. &nbsp;Most performance 'tune-ups' should be made to the stored procedures and the way you use the server. &nbsp;Move frequently accessed data to smaller tables. &nbsp;Clear logs by doing backups.</p> <p>IT Contracts Job Search - &lt;a href=&quot;<a rel="nofollow" target="_new" href="http://www.acmecontracts.com&quot;">http://www.acmecontracts.com&quot;</a> title=&quot;ACME Contracts&quot;&gt;ACME Contracts&lt;/a&gt;</p>