The "Usual Suspects" That Inhibit Application Scalability
There are many "Usual suspects" to tackle when designing applications that scale well on SQL Server, including join depth and schema design, "Chatty-ness" between tiers, recompiles, latching and locking and the use of genuine set based logic, to name but a few. Moreover these issues need to be addressed in a certain order, otherwise this can result in performance glass ceilings being built into an application from day one. This information is presented in ten points in the order in which they should be addressed during an application's design and development life cycle. The points covered are more oriented towards OLTP style applications than OLAP applications.
Sorry, there are no downloads available for this session.
Chris is a freelance SQL DBA / developer who has been using SQL Server since 2000, his passion is for scaling SQL Server and understanding how the engine behaves at depth when pushed to its limits.
The video is not available to view online.