Statistics and Query Optimization

The session starts off by demonstrating how statistics directly affect execution plans and how those plans affect performance in order to establish immediately the importance of statistics. We then go over how statistics are stored and generated including a detailed breakdown of the information contained within DBCC SHOW_STATISTICS so that the attendee will be able to accurately interpret their own statistics. From there we walk through how statistics are created, both automatically and manually, in support of better execution plans. We'll also cover various mechanisms used to maintain statistics since having accurate statistics is one of the most important things you can do from a performance tuning aspect. Throughout I'll demonstrate mechanisms for monitoring statistics, observe behavior of the creation and update of statistics, all using up to date tools. We'll even cover some of the new information available through SQL Server 2014 monitoring as well as changes to cardinality estimations within SQL Server 2014.
Presented by Grant Fritchey at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Grant_Fritchey.jpg
    Grant Fritchey, SQL Server MVP, works for Red Gate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server 2008 Query Performance Tuning Distilled (Apress). He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG). He earned the nickname “The Scary DBA.” He even has an official name plate, and displays it proudly.
    http://scarydba.com http://scarydba.com/feed
  • Video
    The video is not available to view online.