Change log

v1.10

• Fixed the high query optimizations tip (1430) to correctly refer to query optimizations rather than query compilations
• Fixed sequence near exhaustion tip (1520) to consider remaining contiguous range rather than full sequence range
• Improved output for 1510 and 1520 to include remaining contiguous range of identity/sequence numbers

v1.9

• Changed the output of data compression candidates tip (1180) to include the index rebuild statement for implementing compression
• Changed the output of top queries tip (1320) to include script execution timestamp
• Fixed the CCI candidates tip (1290) to correctly filter out smaller tables

v1.8

• Fixed two tips to skip memory-optimized tables as not relevant in the context
• Added a tip for inefficient page compression (1540)

v1.7

• Added a tip for column collation not matching database collation (1460)
• Added a tip for indexes with excessively large keys (1470)
• Added a tip for disabled indexes (1480)
• Added a tip for indexes with low fill factor (1490)
• Added a tip for non-unique clustered indexes (1500)
• Added a tip for IDENTITY range near exhaustion (1510)
• Added a tip for sequence range near exhaustion (1520)
• Added a tip for disabled or not trusted constraints (1530)
• Changed to update statistics on Query Store tables to improve performance of top queries tip (1320)

v1.6

• Added a tip for local storage approaching maximum local storage limit (1450)

v1.5

• Added a tip for disabled row or page locks (1440)
• Added detail cardinality to output of multiple tips
• Added index size to output of little used indexes tip (1170)
• Fixed STRING_AGG overflow in many tables with no indexes tip (1410)
• Fixed arithmetic overflow in notable network connectivity events tip (1380)
• Fixed lock blocking tip (1420) to show short wait time correctly
• Fixed a typo in tip name
• Fixed queries used in top queries hint (1320) to use parameter sniffing

v1.4

• Fixed btree indexes with GUID columns tip (1100) to include Full-Text, XML, spatial indexes in object size calculation
• Fixed CCI candidates tip (1290) to not recommend CCI for tables with unsupported data types
• Added a tip (1430) to report on high rate of query compilations
• Fixed tip exclusion to work when multiple tips are produced by the same query in the script

v1.3

• Added a tip (1420) to report on recent notable blocking
• Improved details for btree indexes with GUID columns tip (1100) to include object row count

v1.2

• Changed large PVS tip (1270) to include database used, allocated, and maxsize info in details
• Changed top queries tip (1320) to include replica updateability info in details
• Changed to only produce compression candidates (1180), CCI candidates (1290), paused resumable index ops (1280) tips on primary
• Worked around a bug in sys.dm_resource_governor_workload_groups_history_ex causing negative memory grant/timeout statistics (1160, 1165)

v1.1

• Fixed to evaluate more tips with lower permissions

v1.0

• Initial release