Analysing indexes

This session isn’t out to teach you how to build indexes, it’s out to give you the tools and techniques to understand how your current indexes are performing. Practical methods to identify and capture index usage and adjust granularity to your working environment. How to use the dmv’s to your advantage. The session is built around the GrumpyOldDBA’s tuning work with tables of several hundred million rows in an ERP application. All code will be provided.
Presented by Grumpy Old DBA at SQLBits I
  • Downloads
    Slide deck available Slide Deck 277 KB
  • SpeakerBIO
    aka colin leversuch-roberts  ( still grumpy! ) Currently supporting a 24 x 7 worlwide billing system in 85 countries. Specialist in performance monitoring and tuning of databases and applications.
  • Video
    The video is not available to view online.