The Tao Of Sql Server - All Comments

Twitter Trackbacks for SELECT * FROM sql_tweeters WHERE location = 'UK' #sqlfaq [sqlblogcasts.com] on Topsy.com

Fri, 31 Dec 2010 19:19:23 GMT

Pingback from Twitter Trackbacks for SELECT * FROM sql_tweeters WHERE location = 'UK' #sqlfaq [sqlblogcasts.com] on Topsy.com

Twitter Trackbacks for Connecting to named Instances Using Port Number - The Tao Of Sql Server [sqlblogcasts.com] on Topsy.com

Thu, 16 Dec 2010 12:49:57 GMT

Pingback from Twitter Trackbacks for Connecting to named Instances Using Port Number - The Tao Of Sql Server [sqlblogcasts.com] on Topsy.com

Memory Impact of file copy on Windows Server 2008 – The Tao Of Sql … | Windows (7) Affinity

Tue, 26 Oct 2010 19:58:30 GMT

Pingback from Memory Impact of file copy on Windows Server 2008 – The Tao Of Sql … | Windows (7) Affinity

SQL Server 2008 R2 and Nehalem Processors | Zamo's Blog

SQL Server 2008 R2 and Nehalem Processors | Zamo's Blog — Wed, 01 Sep 2010 16:34:17 GMT

Pingback from SQL Server 2008 R2 and Nehalem Processors | Zamo's Blog

Sql Server Consolidation and Configuration Part 2 Network - The … Debt on Me

Sql Server Consolidation and Configuration Part 2 Network - The … Debt on Me — Fri, 27 Aug 2010 12:51:20 GMT

Pingback from Sql Server Consolidation and Configuration Part 2 Network - The … Debt on Me

Sql Server Consolidation and Configuration Part 2 Network - The … Debt on Me

Sql Server Consolidation and Configuration Part 2 Network - The … Debt on Me — Fri, 27 Aug 2010 12:51:15 GMT

Pingback from Sql Server Consolidation and Configuration Part 2 Network - The … Debt on Me

Sql Server Consolidation and Configuration Part 2 Network

The Tao Of Sql Server — Fri, 27 Aug 2010 12:35:11 GMT

An often neglected part of Consolidation is the network configuration of a server. If you have mirroring

Sql Server Consolidation and Configuration Part 2 Network

The Tao Of Sql Server — Fri, 27 Aug 2010 12:35:09 GMT

An often neglected part of Consolidation is the network configuration of a server. If you have mirroring

re: To Hyperthread or Not To Hyperthread

blakmk — Sat, 07 Aug 2010 12:10:09 GMT

mastic, the 10% HT benefit for TPC-H is mentioned in this article: www.qdpma.com/Benchmarks_TPCH.html

I think the maxdop setting is just a guide from him, which im sure could be tweaked either way. As with anything like this the best way is to test on your own environment.

GrumpyOldDBA, I used to think the same however it appears the SQLCAT team are recommending turning this on as the original problems with HT are not present in Nehalem. However as with anything it all depends on the environment. My personal take on this is not to use on DW because the performance gains are not compelling.

If either of you have any recent experiences with Nehalem I would be interested to hear.

re: To Hyperthread or Not To Hyperthread

GrumpyOldDBA — Fri, 06 Aug 2010 11:16:52 GMT

It's more than just a case of turning it on and getting +30%. Adding HT doubles your schedulers, each scheduler takes resource especially on an x64 system so you could find you get serious issues. setting maxdop is to a certain extent application dependant and just doubling your schedulers , which is similar to doubling the cores/cpu count, will only give you gains if your current resource is under pressure. A good many people got burned thinking lots of cores would give lots more performance, it's bit like buying car that has a top speed of 155mph instead of 100mph, if you only ever drive at 50mph you'll not see a difference.