Simon Sabin
Simon has worked with data for all his career.
He works with companies on,
1. Data platform strategy
2. Data platform optimisation
3. Data development practices
He founded SQLBits, is a SQL MCM and an Microsoft MVP since 2005
WMV files are unsupported
SQLBits 2009
Performance Tuning your TSQL
A indepth insight into performance tuning database applications.
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