True SQL Server Detective

True SQL Server Detective

PASS Data Community Summit via YouTube Direct link

Agenda

2 of 21

2 of 21

Agenda

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

True SQL Server Detective

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Introduction
  2. 2 Agenda
  3. 3 Why query is slow
  4. 4 Query Text
  5. 5 Wait Time
  6. 6 System Sessions
  7. 7 Most Recent SQL Handle
  8. 8 Query Update
  9. 9 Input Buffer
  10. 10 Where is my database
  11. 11 The default trace
  12. 12 Checking the default trace
  13. 13 File size is not reducing
  14. 14 Shrink
  15. 15 Index oops
  16. 16 Shrink oops
  17. 17 Three allocation units
  18. 18 Radical changes
  19. 19 CPU boring
  20. 20 CPU cleanup
  21. 21 Butterfly Effect

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.