A client runs a large news web site with hundreds of thousands of articles in the content tree. Over the time the web site performance rapidly went down.
When the client checked the SQL server resources, they realized that the usage had increased significantly. Further investigation with SQL Profiler revealed that the issue is caused by having more than 1,000 pages under a single parent page, which is against the best practices.
To prevent this from happening again, the customer created a custom report in the Reporting application that automatically sends an email notification once per week reporting the status of the content tree. Next, they implemented a new business rule that automatically adjusted and organized the content tree structure to comply with the best practices.
After this incident, the client also started monitoring resources of all the servers with New Relic
, set up the Kentico Health monitoring
feature to monitor application performance, and started regularly checking the size of the database tables. Now they will be notified before visitors notice any issues.