M10987 Performance Tuning and Optimizing SQL Databases - Seminar / Kurs von brainymotion AG

Inhalte

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Lernziele

1 - SQL Server Architecture, Scheduling, & WaitsSQL Server Components and SQL OSWindows Scheduling vs SQL SchedulingWaits and QueuesLab: SQL Server Architecture, Scheduling, and Waits2 - SQL Server I/OCore ConceptsStorage SolutionsI/O Setup and TestingLab: Testing Storage Performance3 - Database StructuresDatabase Structure InternalsData File InternalsTempDB InternalsLab: Database Structures4 - SQL Server MemoryWindows MemorySQL Server MemoryIn-Memory OLTPLab: SQL Server Memory5 - Concurrency & TransactionsConcurrency and TransactionsLocking InternalsLab: Concurrency and Transactions6 - Statistics & Index InternalsStatistics Internals and Cardinality EstimationIndex InternalsColumn Store IndexesLab: Statistics and index Internals7 - Query Execution & Query Plan AnalysisQuery execution and optimizer internalsAnalyzing query plansLab: Query execution and query plan analysis8 - Plan Caching & RecompilationPlan cache internalsTroubleshooting plan cache issuesQuery storeLab: Plan caching and recompilation9 - Extended EventsExtended events core conceptsImplementing extended eventsLab: Extended events10 - Monitoring, Tracing, & BaseliningMonitoring and tracingBaselining and benchmarkingLab: Monitoring, Tracing and Baselining11 - Troubleshooting Common Performance IssuesTroubleshoot CPU performanceTroubleshoot memory performanceTroubleshoot I/O performanceTroubleshoot Concurrency performanceTroubleshoot TempDB performanceLab: Troubleshooting common performance issues

SG-Seminar-Nr.: 5150539

Anbieter-Seminar-Nr.: 855707727

Preis jetzt anfragen

Seminar merken ›

Semigator berücksichtigt

  • Frühbucher-Preise
  • Last-Minute-Preise
  • Gruppenkonditionen

und verfügt über Sonderkonditionen mit einigen Anbietern.

Der Anbieter ist für den Inhalt verantwortlich.

Über Semigator mehr erfahren

  • Anbietervergleich von über 1.500 Seminaranbietern
  • Vollständige Veranstaltungsinformationen
  • Schnellbuchung
  • Persönlicher Service