sqladventures.com

Hier meine Ablage für wichtige Themen:

Execution Plans, Query Optimizer

Wie lese ich einen Execution Plan?

Compute Scalars, Expressions and Execution Plan Performance

http://sqlblog.com/blogs/paul_white/archive/2012/09/05/compute-scalars-expressions-and-execution-plan-performance.aspx

Query Optimizer Deep Dive – Part 1

http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-1.aspx

Query Optimizer Deep Dive – Part 2

http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-2.aspx

Query Optimizer Deep Dive – Part 3

http://sqlblog.com/blogs/paul_white/archive/2012/04/29/query-optimizer-deep-dive-part-3.aspx

Query Optimizer Deep Dive – Part 4

http://sqlblog.com/blogs/paul_white/archive/2012/05/01/query-optimizer-deep-dive-part-4.aspx

Inside the Optimizer: Plan Costing

http://sqlblog.com/blogs/paul_white/archive/2010/09/01/inside-the-optimizer-plan-costing.aspx

All about Statistics

Statistics and Recompilations

http://erinstellato.com/2012/01/statistics-recompilations/

Statistics and Recompilations, Part II

http://erinstellato.com/2012/02/statistics-recompilations-part-ii/

Partition Elimination

An Introduction to Partition Elimination

http://sqlskills.com/blogs/conor/post/An-Introduction-to-Partition-Elimination.aspx

Partition Elimination 202

http://sqlskills.com/blogs/conor/post/Partition-Elimination-202.aspx

MAXDOP

The Degree of Parallelism decision is applied to each parallel operator of the plan

The ins and outs of MAXDOP

http://blogs.msdn.com/b/cindygross/archive/2011/01/28/the-ins-and-outs-of-maxdop.aspx

Unterschied zwischen Threads per SPID in sysprocesses und MAXDOP?

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/01/05/why-do-i-see-more-threads-per-spid-in-sysprocesses-than-maxdop.aspx

SQL Server Per Query Degree Of Parallelism Worker Count(s)

http://blogs.msdn.com/b/psssql/archive/2008/02/13/how-it-works-sql-server-per-query-degree-of-parallelism-worker-count-s.aspx

Virtualization

Managing SQL Server on VMware

http://www.brentozar.com/sql/virtualization-best-practices/

SAN Storage

SAN Storage Best Practices for SQL Server

http://www.brentozar.com/sql/sql-server-san-best-practices/

IO Queue Depth Strategy           (Äußerst, äußerst wichtig!!!)

http://sqlblog.com/blogs/joe_chang/archive/2010/10/18/io-queue-depth-strategy.aspx

Storage Configuration

http://sqlblog.com/blogs/joe_chang/archive/2010/04/04/storage-configuration.aspx

Übersicht über die EMC – VNX Reihe

http://www.qdpma.com/Storage/EMC_VNX.html

Lock Pages In Memory (LPIM) – Wichtig für Virtualisierung

Lock Pages in Memory

http://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/

SSAS2008 – Dynamic Management Views für AS2008

SSAS DMV (Dynamic Management View)

http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/

Dynamic Management Views für die SQL2008-Engine

Diese werden monatlich vom Blogger geupdatet.

http://sqlserverperformance.wordpress.com/tag/dmv-queries/