Database Administration & Maintenance

DPT08 Stop Indexing the Query – Part II

11/19/2024

2:45pm - 4:00pm

Level: Intermediate to Advanced

Robert Mandeville

Senior Manager, Product Management for Database Solutions

SolarWinds

Are you still indexing queries? Come and get a quick recap on an evolved indexing strategy based on real workloads as well as vNext thoughts as we continue on our journey to be more intelligent about how we index. We’ll run through taking tuning to new heights and even review the methodology and scripts used to go after the right data to make good decisions.

You will learn:

  • What have we been doing wrong?
  • What could be a better methodology
  • Give me some scripts to leverage in my environment
  • Go after "producing steps" in my query plans
  • Time permitting, show me what this looks like