קורס Performance Tuning ב-SQL Server בשבוע הבא

16 באוקטובר 2013

תגיות: ,
אין תגובות

אני מעביר קורס שיפור ביצועים ב-SQL Server בשבוע הבא – 23/10. למי שמעוניין, אפשר להירשם באתר של ג'ון ברייס:

http://www.johnbryce.co.il/professional-courses/sql-server-advanced-performance-tuning

 

האג’נדה:

 

Detecting bottlenecks

  • SQL Server Profiler & traces
  • Performance Monitor
  • SQL Server Management Studio
  • Database Engine Tuning Advisor
  • DMVs

Database design

  • Normalization
  • Keys vs. indexes
  • Choosing the clustered index
  • Partitioning
  • Choosing the right data types
  • Computed columns

Indexes and statistics fundamentals

  • Index internals
  • Clustered and non-clustered indexes
  • Fill factor
  • Covering indexes
  • Indexed views
  • Index maintenance
  • Understanding statistics

Optimizing Query Performance

  • Duration, I/O, CPU consumption and query cost
  • Index usage
  • Choosing join type
  • Using hints
  • Data type conversions
  • Key & RID lookups
  • Index intersection
  • Common programming issues
    • Bit columns
    • Search by dates
    • EXISTS, JOIN and IN
    • UNION and UNION ALL
    • User defined functions usage
    • OR operator

Code optimization

  • Benefits of stored procedures
  • Multiple search conditions
  • Cursors
  • Temporary tables
  • Code enhancements in latest SQL Server versions

Execution plans

  • Understanding execution plans
  • Compilation process
  • Execution plan elements
  • Execution plans recompilation – pro’s and con’s
  • SARGs
  • Types of joins
  • Caching

Locks, blocks and deadlocks

  • Understanding locking
  • Detecting blocks
  • Detecting deadlocks

Application Design

  • Logical and physical design
  • Queries
  • Transaction control
  • Minimizing blocks and deadlocks
  • Concurrency

New performance related features in latest SQL Server versions

  • Resource Governor
  • Data Compression
  • Filtered indexes
  • AlwaysOn as a scale out solution

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *