Offering : SQL Server 2005 - Performance Tuning and Optimisation Online, Onsite Training
Posted on November 04, 2009 05:37 am - All Ads by this Poster - Email to friend
Safety Warning
Users are recommended to deal face-to-face and avoid distant users. eClassifieds4U does not offer any payment/transaction services.
Read more about Safety Tips.
Details:
- Price
- (Contact Us)
- Area Served
- Professional courses
- Available in Weekends
- Yes
- Location
- Bangalore, M4B 1B3
View Map - Phone
- 44 20 7993 8018
Description:
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
