Performance problem

Hello

We have huge problem with performance on a very small nopCpmmerce 3.00 website(5000 products). Pages are not loading at all, page load can be few minutes, a lot of timeout errors in the log, I know that the first thought is to check database connection and it's working, the database connection isn't a problem we are sure.

Miniprofiler doesn't show what methods cause the problem, and I don't know where to start.

What can it be? Where should we look?

Thanks

Alex

Hi,

Use fiddler(free resource) to monitor what exactly blocking your page from loading

https://www.telerik.com/fiddler

I know that server responds slowly, how fiddler can help?

in case you are saying that DB connection is fine and only pages loads slowly then test with fiddler to analyze which page or script is creating much load

before this try below steps as may be your issue will be resolved

1. Clear the log file of your SQL DB
2. Clear the Cache of nop store and check the system logs again to find any errors

Thanks

DB connection is fine, but site responds very slowly, it's not front-end problem definitely, something with settigs server or database

I did clear cache and restart app, how can I clean up site database from log entries?

Maybe some other scripts?

follow below steps for SQL db maintenance

Go-to you SQL database management studio-click on properties by selecting database-Files and check log file size

if the file size is much heavy then needed to clear and generate new one

also check that log file has been set to auto-grow and your disk space where your database file resides

Follow steps mentioned on Microsoft tech net to clear log files

https://docs.microsoft.com/en-us/sql/relational-databases/databases/delete-data-or-log-files-from-a-database