PERFORMANCE ISSUE

Hi,

I am running nopcommerce 3.6 with 1500 product and 80000 users. When i create a sale on my store then there are up to 10,000 concurrent users and the site becomes too slow. I also run load test with 1000 concurrent users but site goes to sleep. My server configuration are also good with:

Windows 2012 R2
Dell Xeon processor 24 Cores
64 x 2 GB Ram

Please guide me about any change in my site or server settings ?

CPU goes to 90% 95%

Wow, I want your problems. We should all be this lucky!

https://msdn.microsoft.com/en-us/library/bb742546.aspx

This should help for the CPU throttling maybe....
You only have 24 cores pumping but you need to find out exactly what's using it.

Just out of curiosity.... I am assuming SQL is the culprit! Right click >task mgr

Have you ever run in MSSQLMS> Database Engine Tuning Advisor?
Are you above the Free sql express version?

Select the Plan Cache option
Select your database workload analysis (database you are using)
you should have 120 of 120 etc. of X of X selected.
You should leave the tuning options alone unless you have lots of store items.
My database has over 60Gigs so I had to turn off Clustered and make index non clustered for performance issues. I had the opposite problem where 95% of my ram was getting used by sql Clustered Index. Had to drop a lot of tables and rebuild but it works just as fast with no ram problems and stable. Oh yeah, I'm running a 8 core low energy Atom computer from supermicro with 32 gigs ram in the basement! I also have an 80 core supermicro gas guzzling server with 80 cores. 4 e7 8860's and 3 hairdryers as power supplies. I want your problem so I can turn that heater on! Sound to me like it most likely is sql tables either not optimized or you tcpip connection for your "network card(s)" are not optimized. See if network card responds to changes use speedtest.net or something close to you.

Offloading Options

IPv4 Checksum Offload: Enables the adapter to compute the IPv4 checksum of packets instead of the host OS, which can help increase adapter performance while also reducing CPU utilization.

TCP Checksum Offload: Allows the adapter to compute the TCP checksum of outgoing packets rather than the host OS, which can help increase transmission performance while also reducing CPU utilization.

UDP Checksum Offload: Enables the adapter to compute the UDP checksum of outgoing packets instead of the host OS, which can help increase transmission performance while also reducing CPU utilization.

Offload TCP Segmentation: Allows the adapter to perform any necessary TCP segmentation of outgoing packets instead of the host OS, which can help increase transmission performance while also reducing CPU utilization.



I would backup the database and completely backup the metal state just in case you blow the os to hell.



You have some work to do! :)

[b]Here's an update that I did to make the database amazingly tiny, faster and more stable.

Google Page Speed site tester here https://developers.google.com/speed/pagespeed/
Gtmetrix Speed tester here https://gtmetrix.com/

Just make sure you test something other than the front page, test something that has 100 images on a page.

These two sites are all you need for web speed optimization.

I had to completely rebuild the database from scratch and the pictures database removed. Something I feared. I had a backup that worked just in case, as well as a complete full metal backup so I took the plunge.

Problem:
I was getting very large unedited image\.PNGS when I used the admin panel in Nopcommerce.

admin>Media> Default image quality (0 - 100): WAS 100% NOW 45%

Obviously, we are concerned about garbage in garbage out but 45% seem spot on for me.

Since media image size was dropped to 45% it appears the file input closely matched file output.
Your file size may vary but this was very important for me as I had over 150k images.

What I did after a few days (since it was still generating images) in Thumbs\00001_0.png
Yes, my server is atom server the lowest form of server there is but it cost 10 electric per month! Plus I can scale if needed to aws or any other servers. I had switched to file system from database this time!

Solution:
I crushed the crap out of the PNG images size using at first lossless, then I went bold to lossy 24.
For me, I couldn't tell the difference but my server definitely could. It's much faster and leaner now.

I tried just about every online png to no avail due to file limitation and size limitations then I used ScriptPNG!

ScriptPNG Download here  http://css-ig.net/scriptpng

This did a batch png shrink while I did something else. I copied my images folder and specifically my thumbs folder, and saved them locally on a high powered super server. I have 80 core machine that completed the task in a few hours.

Note: ScriptPNg will peg your CPUS at 100% and overheat your machine so you will either need to do 20 mins on and off Or download cupid monitor free version here http://www.cpuid.com/softwares/hwmonitor-pro.html
This will only watch your cpu temps nothing else.

Also you must have speedfan http://www.almico.com/speedfan.php lower your cpu temps using this. It will still be at 100% but you can drop the temps using this program.

ScriptPNG is no joke. Its super fast and it will get the job done for nop users just beware if using your own equipment! If you can render in the aws cloud do that then no worries.

File optimizer is a program you don't need speedfan . It does a great job of shrinking pngs and jpgs but you may be dead by the time it completes if you have a lot of files.

http://nikkhokkho.sourceforge.net/static.php?page=FileOptimizer

Hope this Image shrinkage helps save hours of pain.








[/b]