The DBA Fundamentals VC offers training and support to individuals interested in a solid DBA foundation.
Next Meeting

Tue, Oct 11 2016 12:30 (UTC+10:00) Brisbane


Statistics and Query Plans

RSVP: https://attendee.gotowebinar.com/register/5476642505750149633

Statistics and Query Plans

If you want to tune queries, you have to look at query plans and you have to understand what they’re showing you. One thing people look for when tuning is “bad cardinality estimates”. If you’ve wondered what that means, and you want to understand how the optimizer uses statistics when creating a query plan, then join me for this session on statistics and query plans. We’ll set the stage with a review of what statistics are, then see how the optimizer uses them and where to find that “cardinality estimate” information in a plan. We’ll also cover the various ways statistics can be updated, explore what happens to plans when those updates occur, and ultimately you will see why understanding how it all works is critical when you’re troubleshooting performance issues. Expect lots of demos so you can truly understand what statistics are, how they're used, and why their management is so essential for good performance.


Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

 

JOIN PASS then add our Virtual Chapter to your list

Please join our chapter by creating a user account.  This can be accomplished by clicking here.  All registered users will be emailed detailed instructions prior to each meeting.  Thanks!  


Present to our Chapter

    *  Send us an abstract, and your biography to DBAFundamentals@sqlpass.org

    *  Put Speaker Request in the Subject

    *  Be patient and we will get back to you.   We get a lot of emails.