SQL Server Missing Index

SQL Server Missing Index Detail Script

SQL Server WaitStats Script

WaitStats Find Script...

SQL Server Long Query Script

SQL Server Long Query Find Script

Why is My Database Application so Slow?

When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.

SQL Server Performance Benchmarking with Patterns

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.

Five Mistakes Performance Tuners Make

Erik Darling explains why your queries aren't scaling in production.

Performance Myths : Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.

Performance Myths: Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.

Performance of OBJECT_NAME() & Co.