Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables

Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.

Know read and write ratio before you tune database performance

A script to get the user table query ratio and update radio,etc

Show running queries

Identify the current statement and its line number within a running batch. Includes a link to the execution plan, if available.

Webinar: Performance Tuning .NET & SQL Code Using ANTS Performance Profiler

In this LIDNUG webinar, Mitchel Sellers walks through performance tuning best practices, and investigates how developers can use ANTS Performance Profiler to explore their application code and the SQL queries and execution plans behind it.

Premature Optimisation

Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.

Find Currently Running Query – T-SQL

Following script retrieves the queries currently executing on the server.

Analysis Services Tabular

NameSQLinConfioIgnite (SolarWinds DPA)

This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.

An Orders of Magnitude Problem (T-SQL Tuning)

When a query suddenly starts taking much longer, what do you do? This story from Jerry