4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

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_Adkin.jpg
    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.
    http://chrisadkin.orgh
  • Video
    The video is not available to view online.