Conversion Error for (Querying the plan cache for index scans & Finding plans with Batch Sorts)

microsoft / tigertoolbox

Toolbox repository for Tiger team

http://aka.ms/sqlserverteam

Other

1.48k stars 740 forks source link

Open sm8680 opened 5 years ago

sm8680 commented 5 years ago

c1.value('@EstimateRewinds','int') AS EstimateRewinds,

For SQL Server 2008 - 2016 I'm getting the following error. 2017 doesn't appear to be an issue

Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the nvarchar value '0.333333' to data type int.

Definitely occurring in Plan Cache for index scans. Potentially in plans with batch sorts.

miksh7 commented 4 years ago

having the same issue

Conversion failed when converting the nvarchar value '2.68802' to data type int.