Performance Tuning your TSQL

I've spent over 10 years tuning SQL databases and I'm still learning new ways to tune my database. In this session we will look at how we can analyse queries and understand how they should perform, how they do perform and most importantly will your application scale when you get more than you and a tester using your application.

Query tuning comes down understanding resource usage. We will look at,

  • How to use Profiler
  • Understanding Query plans
  • Key monitors in System Monitor
  • Identifying Resource usage
  • How SQL Server uses resources internally
Presented by Simon Sabin at SQLBits IV
  • Downloads
    Video available WMV Video 198 MB
  • SpeakerBIO

    Simon runs a Data Consultancy enabling companies to make the most of the data they have.

    He has worked with data for all his career and worked with companies across all industry sectors including online retail, insurance, finance, motor sport.

    He works with companies to help them

    1. Improve their data development practices including implementation of devops, agile methodologies and continuous integration.

    2. Understand and define a cloud data platform strategy.

    3. Optimise their data platform, including performance, scalability, security and certification

    Education of people is at the heart of what Simon and his company stand for. it is epitomised by SQLBits, which Simon founded in 2007. Its the largest SQL Server conference outside of Europe and many view as the best in the world, always maintaining a free element and ensuring education for everyone.

    He is also a SQL Microsoft Certified Master and has been Microsoft MVP since 2005

    You can follow him @simon_sabin or read his blog
  • Video