|
By saturation - Wed 24 Oct 2012
|
I want to SQL Server to put some indexes on my Kartris database to improve the performance. Does anyone know if running the SQL Server Database Engine Tuning Advisor and applying the recommendations will adversely affect either
a) customizations to the database; b) the overall performance of Kartris; c) affect future upgrades?
|
|
By Mart - Fri 26 Oct 2012
|
Which version of Kartris are you running?
The one thing I do know is we put an awful lot of effort into tuning the queries already... this has been an ongoing effort since we launched kartris... we have one client running with well over a million products in the database - and such a site gave us a great deal of data with which to work on tuning of the database.
Are you seeking to address any specific issues, any particular parts of the site that you think require optimization?
|
|
By saturation - Fri 26 Oct 2012
|
Yes--it seems on my product list and product detail pages they can take anywhere from 3-15 seconds to load. I have 6GB of RAM, plenty of disk space, 2 processors. I've rebuilt the indexes, shrunk the log file, and still am getting slowness.
Any other ideas?
|
|
By Paul - Tue 30 Oct 2012
|
Are you sure there isn't anything else running on those pages?
I had a client a month or two back who reported their site was running very slow. It turned out not to be database related at all; they had something in the skin which was connecting to a remote XML feed to get latest news. The remote feed was down, so their site was waiting for a response (which eventually timed out) before it served out any pages.
I would be extremely surprised if that slowness was in the kartris database. We have customers running sites with a million items in on similar spec'd servers to yours and even the search results are snappy, coming back in 1-2 seconds.
|
|
By saturation - Fri 9 Nov 2012
|
|
I went to pingdom.com and it's showing 7.26 seconds for one of my product pages...It appears that it's trying to re-download the CSS files several times. Any ideas why that would be happening? I'm not convinced it's Kartris that's the culprit, but it is the only thing running on that server (obviously with SQL Server), and 8 GB of memory and plenty of disk space. Let me know your thoughts.
|
|
By Mart - Fri 9 Nov 2012
|
|
Can you send me the URL by personal message if you don't want to post it here publicly. Definitely sounds like something weird going on
|
|
By Paul - Fri 23 Nov 2012
|
Ok, regarding it trying to download CSS files and the slowness, I think I know what the problem is.
With ASP.NET 4 running in 'integrated' mode, every request is dealt with by the app (i.e. kartris). This includes 404s.
Now consider if you have background images in your CSS files that aren't present on your server. As each page is called in a browser, you get a cascade of errors as those images in the CSS generate 404s which come from Kartris rather than a static file page, and so contain the CSS files that generate more errors and so on.
You can try switch the app to classic mode to see if this speeds things up, as in that case only aspnet specific files will be handled by Kartris, everything else would just get the standard server 404 page. Also, examine your CSS files to ensure that any images you reference do exist, and also your skins to make sure they are not calling any other content that creates a 404.
THis is almost certainly what is killing your performance. I think we will look at ways of serving a simpler 'not found' page for 404 requests.
|
|
By saturation - Fri 23 Nov 2012
|
I can't run my site in any mode except .NET 2.0 Integrated. I tried .NET 2.0 Classic, .NET 4.0 Integrated, and .NET 4.0 Classic, and they all generate errors at the home page--that's after restarting the AppPool and restarting IIS.
Should this site be able to run under any other mode?
|