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.
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