Concept : Performance Tuning - SQL

PERFORMANCE TUNING:

The Method of performance tuning contains of identifying performance bottlenecks, Specializing problems, and Resolving issues of their presence.

ISSUES:

1. Performance of the web-site is Littile Bit slow. 
2. Execution of the perticular query taking Much More time.

Performance tuning performs following Steps.

• Isolation level of a perticular query.
• Minimizing blocking, deadlocks And Locks.
• Execution plan analysis.
• Using database engine tuning advisor.
• Indexing maintenance and fragmentation analysis.
• Data design analysis.
• Query design analysis.
• Calculate resource consumption At server level.