I started off with an HP server with 2 CPUs and total of 16 cores running at 1.8 GHz clock speed. Some of my long term clients with a lot of encounters took up to 60 seconds to close. When you hit Sign Off or the Accounts Tab and watch the performance monitor, only a single thread of a single core will be maxed out. Thus, raw clock speed is all that matters. Dr. Joe from Arizona
That has always been the case for SQL Express. See my earlier post:
Originally Posted by Sandeep
...it shouldn't be restricted to 1 core but 4 cores. It's one reason why people with i7 Processors have better performance than Xeon users due to the higher clockspeed of the 4 cores. SQL full is multi-threaded, but SQL Express benefits from higher clocked cores.
.png "ACUF Donor I")
