Performance

Home SQL .NET Exchange Opinion Blogs Forums About

SQL Home > Performance

Investigating SQL Server 2008 Wait Events with XEVENTS

by Mario Broodbakker | 24 July 2008 |

Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy a problem, especially when a SQL Statement is being forced to wait. Now, in SQL Server 2008, come XEvents, which allow you to... Read more...

Execution Plan Basics

by Grant Fritchey | 11 May 2008 |

29 comments |

Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why isn't my index getting used? Why does this query run faster than this... Read more...

SQL Server Performance Crib Sheet

by Grant Fritchey | 31 May 2007 |

26 comments |

Grant Fritchey provides an eagle-eye view of effective tools, strategies and techniques for SQL Server performance measurement, tuning and testing. Read more...

Taking the Guesswork out of SQL Server Performance Profiling Part 2

by Mario Broodbakker | 18 May 2007 |

5 comments |

SQL 2005 wait event statistics are a good step forward, but are only useful for isolated testing, and to get a global impression on how the SQL Server is spending its time. Mario Broodbakker demonstrates why it would be much better if SQL Server collected those... Read more...

SQL Server Wait Events: Taking the Guesswork out of Performance Profiling

by Mario Broodbakker | 22 March 2007 |

7 comments |

Measuring what is actually happening is always the best course of action when investigating performance issues on databases, rather than relying on cache hit ratios, or best practices, or worst of all, guesswork. This article introduces some techniques that will... Read more...

SQL Server Performance Testing

by Grant Fritchey | 15 May 2006 |

12 comments |

When faced with two viable solutions to a badly compromised database design, one using clustered indexes and the other compound primary keys, Grant Fritchey took the only sensible route: he gathered hard performance data... Read more...

Performance tuning tips for database developers

by Andy Warren | 17 May 2005 |

12 comments |

Performance tuning is not easy and there aren’t any silver bullets, but you can go a surprisingly long way with a few basic guidelines. Read more...

Learn SQL Server (19 articles)

SQL Training (3 articles)

Database Administration (35 articles)

SQL Server 2005 (21 articles)

T-SQL Programming (45 articles)

Performance (7 articles)

Backup and Recovery (15 articles)

SQL Tools (27 articles)

SQL Home

Learn SQL Server (19 articles)

SQL Training (3 articles)

Database Administration (35 articles)

SQL Server 2005 (21 articles)

T-SQL Programming (45 articles)

Performance (7 articles)

Backup and Recovery (15 articles)

SQL Tools (27 articles)

The Wrong Fabia

There is often more than a twinge of embarrassment when an Email goes astray, and is received by the wrong person....

RECENT BLOG POSTS:

VB.NET: The Ugly Duckling

SQL Server Tumbleweed Awards

CLR, beer and turkey

View the blog

Beginning SQL Server 2005 Reporting Services Part 1

Steve Joubert begins an in-depth tour of SQL Server 2005 Reporting Services with a step-by-step guide... Read more...

Ten Common Database Design Mistakes

Database design and implementation is the cornerstone of any data centric project (read 99.9% of... Read more...

SQL Server Full Text Search Language Features

SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast... Read more...

Beginning SQL Server 2005 Reporting Services Part 2

Continuing his in-depth tour of SQL Server 2005 Reporting Services, Steve Joubert demonstrates the most... Read more...

Executing SSIS Packages

Nigel Rivett demonstrates how to execute all SSIS packages in a given folder using either an SSIS... Read more...

Site map | Become an author | Contact us