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.
Presented by Chris Adkin at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    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.
  • Video
    The video is not available to view online.