SQL Performance Optimization

Here we list the techniques for optimizing the query performance:

Query Execution Plans


Partitioned Tables

Partitioned Indexes

 Partitioned Heap


Covering Indexes

Filtered Indexes

Indexed Views

Report/DW Query Optimization


Routine Aggregation Using Summary Tables

Performance Monitoring

Monitoring Tools

Key Query Performance Metrics

Management Data Warehouse and Data Collection Components

Performance Tuning

Query Tuning Based on Disk I/O


Using Execution Plans for Tuning

Isolation Levels

Best Practices

Leave a Reply

Your email address will not be published. Required fields are marked *