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

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

Open sm8680 opened this issue 5 years ago • 1 comments

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.

Jun 19 '19 12:06 sm8680

having the same issue

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

Aug 19 '20 20:08 miksh7