SQL Server Power Search - Get More Relevant Results

SQL Server Performance Tips

This section of the site contains SQL Server performance tips and articles to help identify and resolve performance problems.

 

A fast SQL Server is something that should be taken for granted, but unfortunately the vast majority of systems do not perform well. The reasons for this can vary, and include database design, hardware bottlenecks, poor coding, poor indexing, inefficient configuration, and many more.

This section of the site brings together articles, hints and tips that may assist you in your troubleshooting, and can help to prevent mistakes from being made in the first place.

max degree of parallelism

This article explains why setting 'max degree of parallelism' to 1 is often beneficial to performance...

SQL Triggers - Design for Performance

SQL Triggers are a powerful tool, but be careful not to overuse them. Inefficient trigger design can have a devastating effect on application performance...

Autoshrink - Don't Do It!

The autoshrink database option is OK in a development environment, but avoid it like the plague on your production servers...

OR Condition Performance

OR condition performance is heavily dependent on correct indexing and efficient coding of the query...

SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...

EVA Partition Alignment

Partition alignment is a well documented best practice, but does it have any benefit on an HP EVA?

Data Warehouse Performance Part 1 - I/O

The first of a series of articles on data warehouse performance. This article focuses on I/O...

SQL Server Performance Checklist

This is a list of factors affecting SQL Server performance. This page will evolve over time...