Introduction to Performance Analysis and Tuning
In this session we will look at the toolset you have available to you to find performance problems in your system. Once you've found the problem you need to solve it. We will show you how you can go about resolving your problems.
We will look at SQL Server profiler, Dynamic Management Views and Perfmon amongst other things to help us identify the problem.
To resolve the problem we will look at Query Plans and SET options to help us identify the source of the problem and look at some resolutions to common problems. This will include changes to queries, table design changes and index changes.
After this session you will have a understanding of the tools available to you to resolve performance problems and how to use them.
- Downloads
Sorry, there are no downloads available for this session.
- 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
- Video
The video is not available to view online.
- Session Files Explorer