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...Not found what you're looking for?
Use this search box. It is tuned for SQL Server searches. Try it and see!