SQL Connection String

Hi guys,

We are using Nop 1.9 and runing well on our VDS.

The problem is in couple of hours we are having very slow load page especially on product details page.

When i check the cpu usage it goes up to 95% and if i reset SQL Server it goes well again.

Do you have any idea to solve it? Especially on product details page we have very slow load.

Thanks

Are you running SQL Server on a Virtual box? Not sure that I have ever heard the term VDS. Correct me if I am incorrect.

SQL Server is very poor performing when it attempts to run on a Virtual anything. You need to use an actual server. That way SQL Server can manage the amount of memory and processing time it needs.

Andrew SQLDBA

Hi Andrew,

We actually using Virtual Dedicated Server but i dont think this cause the problem.

Everything works fine on my website http://www.mark-ha.com but product details page.

For example;

http://www.mark-ha.com/2014-mayo-modelleri-2014-bikini-modelleri

opens fast enough.

But;

http://www.mark-ha.com/kom-sporel-mayo

takes 8 - 12 second to open.

Every single category or manufacturer pages works quiet fast. Only the product details pages dont work well


If i shut the sql for 1 minute and re open again, everything works well but in couple of minutes it goes slow again.


Any idea to solve my problem?

Thanks in advance

Ali Caliskan

Time to run a profiler trace on this code. Also look at the query in the stored procedure to see what it is actually doing. The trace will tell you exactly what is going on, and why the large amount of time taken.

Andrew SQLDBA

After looking at both pages, and comparing what is shown on each, I suggest that you turn off or comment out the magnification on the page with the women, and see if that makes a difference. I cannot see the code in the page view, so I could not tell you what is going on. Comment as many features, or code that was not original, and then turn on Profiler to trace each page hit. Then, uncomment features, one at a time, and load the page, while profiler is running.

Still run SQL Profiler trace and hit each page, and then with and without the magnification feature on the page with the women.

As a SQL DBA, I never, ever use a Virtual box to run my databases on. Microsoft even states that on their website.

Andrew SQLDBA