MSSQL Server 2005 Performance Tuning and Optimisation

MSSQL Server 2005 Performance Tuning and Optimisation

Measuring Database Performance

• Importance of benchmarking
• Key measures for query performance: sysmon
• Key measures for query performance: profiler
• Guidelines for identifying locking and blocking

Optimizing Physical Database Design

• Performance optimization model
• Schema optimization strategy: keys
• Schema optimization strategy: responsible denormalization
• Schema optimization strategy: generalization

Optimizing Queries for Performance

• Performance optimization model: queries
• What is query logical flow?
• Considerations for using subqueries
• Guidelines for building efficient queries

Refactoring Cursors into Queries

• Performance optimization model: query-set-based solutions
• Five steps to building a cursor
• Strategies for refactoring cursors

Optimizing an Indexing Strategy

• Performance optimization model: indexes
• Considerations for using indexes
• Best uses of the clustered index
• Best practices for non-clustered index design
• How to document an indexing strategy

Managing Concurrency

• Performance optimization model: locking and blocking
• Multimedia - "How to use efficient queries to reduce locking and blocking"
• Strategies to reduce locking and blocking

Top