I am running a Windows 2008 server (VPS with 1 GB of RAM) with SQL Server Express and IIS 7 installed. On this I host a NopCommerce 1.7 site with a database of about 26,000 products.
Now I am the only user of the website (it is under development), and I get pretty poor performance from it. To be more specific every time I make a request, the workflow shifts to 90-100% CPU usage for a few seconds. Is it me or is it a lot for 1 custom NopCommerce site? Any ideas why this is happening and what can I do to fix or continue the investigation?
PS: a workflow uses between 160 MB and 400 MB of memory (private working set) and SQL Server with this database Do you have any suggestions besides the obvious to get more RAM? I intend to get another GB, but I am afraid that this will not solve the problem of using the processor.
source
share