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
Speaker focus
Simon is an independent Database consultant specialising in the world of search, distributed architectures, business intelligence and application development. He has worked with SQL Server since 1998 and has always focused on high performance reliable systems. He was awarded as an MVP in 2006 and is regular speaker at SQL Server events as well as writing for SQLServerCentral and Simple-Talk.com.
Other sessions from this conference