Sql Server Express has the following major hardware limitations that has a consequence on performance:
1GB of memory
My question is: if on a multicore machine many instances of sql server express are running, which processor does each instance use?
Example: Dual Core - 4 Sql server express instances (SS1, SS2, SS3, SS4)
SS1 - Core1
SS2 - Core2
SS3 - Core1
SS4 - Core2
Or all the instances use the same cpu (Core1)?
If not, how does the Sql Server Express instance choose the Core to use?