Microsoft SQL Server Performance Top Tip: Multi Processor (SMP) Box Doesn’t Use All It’s Processors

SQL Server Performance Top Tip: Multi Processor (SMP) sudden death syndrome.

Mat Stephen's WebLog — Wed, 02 Feb 2005 16:26:00 GMT

Sql performance and available cpu's

Ramon Smits — Wed, 02 Feb 2005 16:57:00 GMT

re: SQL Server Performance Top Tip: Multi Processor (SMP) Box Doesn’t Use All It’s Processors

Toine de Greef — Wed, 02 Feb 2005 23:53:00 GMT

Would this also apply (to a lesser degree) to MSDE and P4 HyperThreading?

(MSDE should be able to use up to 2 processors - or would overhead kill performance?)

re: SQL Server Performance Top Tip: Multi Processor (SMP) Box Doesn’t Use All It’s Processors

Matthew Stephen — Fri, 04 Feb 2005 18:37:00 GMT

Yes - I guess it would apply to MSDE on a two proc P4 with HyperThreading.
INF: SQL 2005 express wil only use one phyiscal processor

re: SQL Server Performance Top Tip: Multi Processor (SMP) Box Doesn’t Use All It’s Processors

rene — Mon, 14 Feb 2005 03:35:00 GMT

But remember/be carefull that a hyper threading core is competing for the CPU Bus and LEVEL 1 Cache and the current Thread shedulers in Win2K3 and Sql2000 are not aware of Hyperthreading so they might schedule the wrong thread as they expect 2 real cpu's.

Good Post!

re: SQL Server Performance Top Tip: Multi Processor (SMP) Box Doesn’t Use All It’s Processors

Matthew Stephen — Mon, 14 Feb 2005 20:15:00 GMT

SQL Server didn't always support Hyper-Threading, but support has been introduced steadily through service packs. Service pack three introduced full support for Hyper-Threading. Full details can be found @ http://www.microsoft.com/sql/howtobuy/SQLonHTT.doc

Microsoft SQL Server Performance Top Tip: Multi Processor (SMP) sudden death syndrome.

Mat Stephen's WebLog — Mon, 28 Feb 2005 02:00:00 GMT

More follow up from my TechNet SQL 2005 presentation (14/6/05) - SMP boxes and database files

Mat Stephen's SQL Server WebLog — Fri, 17 Jun 2005 00:26:09 GMT

During my TechNet presentation on Tuesday evening (14/6/05 in Reading), I got a little side tracked and,...

Uso de varios procesadores | hilpers

Uso de varios procesadores | hilpers — Thu, 29 Jan 2009 21:02:24 GMT

PingBack from http://www.hilpers-esp.com/712073-uso-de-varios-procesadores