Multi_threading
-
Hi all,
With dual-core & quad-core cpu's on our doorstep, Does anyone know which components of sql 2005 use multi-threading? Is there a differance bewteen multithreading components depending on version (Standard V Enterprise)?
Are there any options you can enable to to take full advantage of multi-threading?
-
Quite simply, SQL Server 2005 Standard and Enterprise Edition both take advantage of Multiple processors or Multi-core and Dual-core as you put it as well in the exact same way.
By default it assigns a cost to queries before they run to determine if multi-threading the execution will be of any benefit, if it exceeds that 'cost' then it flips on parallelism (multi-threading) and runs the query across as many processors as it thinks it needs to in order to run the query as efficiently as possible.
So...in short.
Yes it takes advantage of multi-core CPU's and no you don't need to do anything extra, it's automatic and does what most people need without any special settings.
Christopher Ford
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply