Adaptive Joins and Memory Grants in SQL Server
Adaptive joins let the optimizer choose between a Hash Join and a Nested Loop join at runtime, which can be fantastic for performance when row count …
Read MoreUse Report View in Perfmon to Compare Database Counters (free video)
Category:
perfmon
, sql-server
Sometimes you need to compare lots of counters at once - for example, counters that report at the database level. This can be frustrating in “Line” view, but the “Report” view in perfmon makes life much simpler.
Video Tutorial
In this four minute video, I show you how to easily compare samples:
RELATED POSTS
