Blitz Result: Date Correlation Enabled

When two tables both have date fields, and the dates in the two tables have related distributions, SQL Server can build better execution plans if it knows about those relationships.  Date correlation is not a default setting, and it has some performance overhead.  It tells SQL Server that date fields in two tables are related, and SQL Server maintains statistics showing that relation.  This part of our SQL Server sp_Blitz script checks sys.databases to see if any of the databases have date correlation enabled.

To Fix the Problem

This may not be a problem: it might actually be a solution! This warning is informational just to let you know more about the server you’re dealing with.

Return to sp_Blitz or Ask Us Questions