Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

2 Answers

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
1  
@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
show 1 more comment

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
add comment

Your Answer

 
discard

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