SQL 2005 adn dual cores, etc

Django x2 · 11 Mar 2009 at 15:49

Hi, Can anyone tell me if SQL 2005 uses both cores (or four cores for quad) of a compatible installed processor in the following cases:

both x86 and x64 platforms
versiosn dependant (Std, Ent)

Thanks

svbooga · 11 Mar 2009 at 17:06

SQL 2005 will use all the available cores on a dual/quad core CPU on both x86 and x64 OS. Only difference is memory support.

For a list of what each version supports see this site:-

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

For more detailed info on the version differences see here
http://msdn.microsoft.com/en-us/library/ms143761.aspx

dangerstat · 11 Mar 2009 at 17:37

Does anyone have the same information for MySQL? Can't get it to use more than one core on any machine I use

iaind · 11 Mar 2009 at 18:38

MySQL should be multithreaded, what OS are you running it on?

dangerstat · 11 Mar 2009 at 18:57

iaind said:
MySQL should be multithreaded, what OS are you running it on?

Debian Lenny x64

and

Fedora Core 10 x64

MySQL doesn't seem multithreaded on either :mad:

iaind · 11 Mar 2009 at 20:15

Are you running a single large query and expecting it to use multiple threads?

I'm not 100% sure but I dont think it works like this, I think you need multiple queries in order for it to start using multiple CPUs