Indexing is a stab in the dark sometimes. Usage patterns in applications may be different than we expect when making choices for indexing and what we as DBAs think are good indexing decisions may work against us in the wild. Join Tim Ford, Jason Hall, and Kevin Kline as they review how to use the SQL Server Dynamic Management Objects and System Views to identify:
• Under-utilized indexes
• Poor clustering decisions
• Index overhead
• Identification of heaps
• Fill factor misconfiguration
• ... and MORE
In addition, you’ll see exciting new features in the free SQL Server tuning tool, Plan Explorer, which help make index analysis much easier and faster. Download the DMV scripts described in the webinar from sqlcruise.com/indexscripts. Download the PDF for Tim’s free eBook at http://bit.ly/2fI8SWY.
About Tim Ford:
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He was a healthcare DBA for 16 years before joining SurveyMonkey in 2015. He also leads SQL Agent Man Consultancy and SQL Cruise events. On SQL Cruise Tim takes 25 students and Thought Leaders in the Microsoft Data Platform Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers.
He enjoys telling stories with data and would love to see you on SQL Cruise in 2017 either in Caribbean in January or Alaska in August. Hurry though before seats sell out!