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 free lance devleoper / DBA with a passion for squeezing performance out OLTP applications which he has practised over a fifteen year career over a variety of sectors within IT.
The video is not available to view online.