I know this is hard to answer without really looking at the code we are using but we are experiencing some performance issues with our Commerce R2 site. We have about 7000+ skus/variations and when loading a page with productlistings the cpu spikes to 50%+ for a single request. Tried some simple load tests with a few user refreshing productpages and then the cpu was constantly 90+%.
The server setup is a dualcore xeon 2.27GHz with 16 GB ram with SQLserver express running on the same machine.
Ran the site through ANTS Performance Profiler and couldn't find anything specific. Have had the site analyzed by EPiServer support without any clear results that could point to the reason for the high cpu load. The only suggestion was separating the web server and database server and upgrade to quadcore.
Anyone got any good idea on how to try to pinpoint performance issues or is Commerce that demanding?
Compaing the site with the demosites there is a huge difference with how much the affect the cpu.
What search are you using for your implementation of Commerce, is it the Lucene version, SQL full-text or another? This can make a difference in terms of IO / performance as you are using the same server for both IIS and DB. However, it does sound quite high CPU utilization, even with this setup.
Found one of the causes. We were using a bad way to get product from variation in our base code and also that we were using CatalogResponseGroup. CatalogEntryFull where we didn't need it. Thanks to EPiServer support.