search

microsoft / tigertoolbox

Toolbox repository for Tiger team
http://aka.ms/sqlserverteam
Other
1.48k stars 740 forks source link

usp_whatsup - version check before dm_exec_function_stats is incorrect #133

Closed DaveDustin closed 5 years ago

DaveDustin commented 5 years ago

https://github.com/Microsoft/tigertoolbox/blob/c8e8211bb3d9e5311ad435ebe8d882c28c9df282/usp_WhatsUp/usp_whatsup.sql#L591

sys.dm_exec_function_stats was introduced in SQL2016 (13) but the version check is set to 11 (2012)

pmasl commented 5 years ago

Thanks, this is fixed now.