In SDL Web, broker database server CPU goes to 100% gradually after browsing to a DD4T webpage and making taxonomy calls
000005974|1/14/2020 4:58 PM
SDL Web 8.5
- When browsing to a particular page on website, DB usage starts to go up to 100% within a minute. - SDL Web 8.5 is installed, and DD4T 2.2 used for website. - Same code was used on a Tridion 2013 SP1 website, and did not exhibit the offending issue. - Queries which are most frequently called and are longest are category/keyword related queries.... components on the page in question use keywords. - Both object cache and application cache (on presentation layer) are enabled. - Other pages besides the offending page will also take excessively long to load, perhaps 30 seconds max. - Below code takes six seconds to execute
var filter = new CompositeFilter();
taxonomyFactory.GetTaxonomyKeywords(tcm:20-76-512, filter, new TaxonomyListFormatter()).KeywordChildren.Cast<Keyword>().ToList();
- Webpages are slow to load when taxonomy hierarchy is hit at the lowest level. Going up the hierarchy tree, page loads are much faster.
Issue will be resolved after: - applying hotfix CD_188.8.131.5249 to content delivery environment. See below article for instructions on how to download hotfix Where can I find hotfixes for SDL Tridion/Web? - ensuring that any custom indexes have the NAMESPACE_ID column.