Sitecore Performance Analysis via Database Profiling
December 27th, 2011
Technology, Web Content Management
The following blog post is part of a series on Sitecore optimization from the forthcoming NavigationArts’ whitepaper entitled “Advanced Sitecore Performance Optimization”. View more posts in this series here http://blog.navigationarts.com/tag/sitecore-optimization/.
Sitecore, like many “frying” CM systems, is fundamentally a dynamic database application, albeit with a thick layer of interface, API, and .NET coding between a programmer and the raw query data. Indeed, SQL is often as much of a workhorse as the production web delivery servers, and most times, more. For that reason, a developer has to be aware of the impact of retrieving data from the SQL Server on load times, and cognizant of other demands on the SQL server’s resources such as 3rd party databases, maintenance plans, and whether configuration has been optimized.
Alan Gallauresi
