During a code review I spotted a query missing its join condition. Here is a script for finding queries without JOIN predicates in SQL Server.
Analysis Services Performance Monitoring: What to Measure
Analysis Services performance monitoring starts with one habit: take measurements before users complain. This guest post by Bill Anton explains what to measure for processing and for queries, and why the OLAPQueryLog table tells only part of the story.
How to Find Queries Running in Parallel in SQL Server
To find queries running in parallel, read max_dop and the CPU to elapsed ratio from the query stats view, then confirm with the plan XML. This post tests both on a two million row table. It also explains why the same query stays serial until its cost passes the threshold.
SQL SERVER – Querying Performance Counters from SQL Server
When SQL Server is slow, where do you start? I look at querying performance counters from inside SQL Server as a quick way to see what is going on.
SQL SERVER – Introduction to Database Engine Tuning Advisor (a.k.a. DTA)
An introduction to Database Engine Tuning Advisor, or DTA, the tool that ships with SQL Server client tools and suggests indexes and statistics.
SQL SERVER – Using “High Performance” Power Plan for SQL Server
A simple, often missed setting on a new server: switch Windows to the High Performance Power Plan. Here is why it matters for SQL Server and where to set it.
Forced Parameterization: When It Cuts CPU and When It Hurts
Test forced parameterization against ad hoc compile pressure with query_hash counts, compilations per second, CPU, and parameter sensitivity.







