"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

May 30, 2011

SQL Server Query Tuning

SQL Server Query Tuning two good posts

Query Tuning Fundamentals: Density, Predicates, Selectivity, and Cardinality
Summary from post
  • Density - Measure of how often duplicates would occur
  • Predicates - Join columns / filter clauses
  • Cardinality - Number of rows returned by query operator
Wide vs. Narrow Plans
Turning a Scan into a Seek With A Pointless Predicate

Thanks to authors of the post. This post is a good reference for me.

More Reads
SQL Server 2008 - Cache Dynamic SQL
Performance Tuning Redefined with SQL Server 2008
Who dropped objects from database?
SQL Performance Trouble Shooting – the basics from Microsoft
Usefull DMV Query
24HOP: SQL Server Performance Tools
How can you tell if an index is being used?
Troubleshooting Performance Problems in SQL Server 2008
Performance Monitor, SQL Counters and Tresholds
What are plan guides and how it could help in managing performance of the queries
How to Find the Amount of Fragmentation on Your SQL Server Instance
SQL Bits Session - High Scale OLTP – LL From SQLCAT Performance Labs
SQL Bits - The Dark Arts-a.k.a Performance Tuning, indexing and query plans
SQL Server Index Tuning for Mere Mortals
The Difficulty with Deadlocks
Completely Legal SQL Performance Enhancements Video
Automating SQL Execution Plan analysis
Tool Link

Very Good Reads!!

1 comment:

jv said...

Looking at the opening image of the video - I'd refine slightly - and say the troubleshooting steps are :
1)Identify existing Problem
2)Monitor and define cause (root) of problem
3)Apply changes to problem
4)Problem Solved