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.

Targeted Index Performance Improvements

This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving these targeted indexes, leading to better performing code.

Indexes

I/O Requests Taking Longer Than 15 Seconds To Complete

This article describes the warning "SQL Server has encountered n occurrence(s) of I/O requests taking longer than 15 seconds to complete on file <filename> in database <dbname>".

Theoretical Performance Issue Handling

Theoretical performance issue handling or handling theoretical performance issues from new author R. C. van Dijk.

Disk Partitiona Alignment Best Practices for SQL Server

Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows.

Twenty tips to write a good stored procedure

This article will provide some useful information to write a SP. I have emphasized on performance.

Using Indexes to Reduce Blocking in Concurrent Transactions

New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.