ARTICLES

Workspace Memory / Query Memory Tuning – RESOURCE_SEMAPHORE / IO_COMPLETION / SLEEP_TASK Waits

Prefetch – Querying at the speed of SAN

Plan Caching and Query Memory - When not to use stored procedure or other plan caching mechanism like sp_executesql or prepared statement

Parallel Sort and Merge Join – Watch out for unpredictability in performance

Parallel Query Memory - MAXDOP and query memory distribution in spotlight

Flying with Plan Freezing – Mostly you experience thrust or stay afloat, but rarely this add-on can be a drag

Finding optimal number of CPUs for a given CPU intensive workload

When to place tempdb in RAM to improve ORDER BY Performance

For further articles please visit http://blog.sqlworkshops.com/

More SQL Server Performance Tuning concepts as well as info on sp_whopro and SQLTest are explained @ SQLVideo.com

To receive example SQL Scripts used in our webcasts and articles: Subscribe to our Newsletter

VISIT ALSO OUR SISTER PAGES