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

SQLServerCentral Runs sp_Blitz - Performance Part 1

The third article that examines the output of the sp_Blitz script™ run against SQLServerCentral's database servers.

How Come the Hourglass? Why Database Applications Slow Down

It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It could be, but there are other suspects that should be considered. Feodor Georgiev describes where, in the long route, to and fro', that a data request makes before returning, that things can get snarled up.