17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

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 is Head of Data at Wonga.com. Prior to Wonga Simon ran a SQL Server Consultancy specialising in performance and scalability.
    He has worked with SQL Server since 6, became an MVP in 2006 and in 2007 founded SQLBits. He is also a SQL Microsoft Certified Master.

    You can follow him @simon_sabin or read his blog http://sqlblogcasts.com
    http://sqlblogcasts.com/blogs/simons http://sqlblogcasts.com/blogs/simons/privaterss.aspx
  • Video
  • Session Files Explorer
    The network name cannot be found.