Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Will MS SQL 2005 Express run and utilize the quad core processor of a Phenom X4 9650?

share|improve this question

It will install and run, however Express will only utilize one processor at a time. There is no parallel processing with Express. Windows will see multiple cores as multiple processors so the quad core will be seen as 4 processors.

See the Engine Specifications section of the SQL Server 2005 Express Edition Overview at MSDN.

share|improve this answer
Hmpf. Why 2005? – TomTom May 7 '10 at 16:11
@Tom: what do you mean "Why 2005?" – squillman May 7 '10 at 16:43
Current version: 2008 R2, released some days ago. 2008 was reolease 2008. 2005 is an OLD version. – TomTom May 7 '10 at 17:25
@Tom: price isn't the only determining factor... – squillman May 7 '10 at 17:42
@TomTom - [1] There's more to compatibility than just the fact that an app has legacy compatibility modes, it has to be tested, [2] The question clearly asked about SQL Express 2005, [3] Chill out. – Helvick May 7 '10 at 18:55

It will work. It will utilize ONE PROCESSOR - which you have (cores do not count, they get utilized). iIt will NOT parallelize, but if you get multiple queries at the same time (web applicaiton, for example, many pages being served at the same time), they will execute in parallel.

At least in 2008 R2 - may I ask why you insist on using a 2005 SERIOUSLY OUTDATED database server? It is not the upgrade costs ;)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.