A Perspective on Database Performance Tuning

Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer or systems administrator.

SARGable

Time Bomb Coding

Do your system contain a time bomb in the code? David Poole looks at some potential situations where you might be experiencing performance issues and delves into why.

See the compile time

Useful if you think a SQL statement, Function, or SPROC is taking too long to compile.

Top 10 steps to optimize data access in SQL Server. Part IV (Diagnose database performance problems)

It’s time for us to learn how to diagnose different performance and related problems in SQL Server database. Take a look at the following articles to learn the step by step process that we’ve already carried out so far.

Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)

Even after you have applied proper indexing along with re-factoring your TSQLs with best practices, some data access routines might still be there, which would be expensive, in terms of their execution time. There must have been some smart ways to deal with these. Yes there are. SQL server offers you some rich indexing techniques that you might have not used earlier. These could surprise you with the performance benefits they possibly offer. Let us start implementing those advanced indexing techniques:

Top 10 steps to optimize data access in SQL Server. Part II (Re-factor TSQLs and apply best practices)

In this article, we are going to focus on writing or refactoring the data access codes using the best practices. But, before we start playing the game, we need to prepare the ground first. So let’s do the groundwork at this very next step:

Using Server Side Traces for Dynamic Performance Evaluation

This article describes a method of gathering and analyzing performance data using SQL Trace.

Performance Improvement: Understanding

This article will cover the core understanding of the performance conversation

Performance Improvement: Understanding

I'm going to try to lay out some general guidelines for performance improvement through improving understanding about what performance is, how to measure it, and finally solutions to common problems. This article will cover the core understanding of the performance conversation.