Come capire il parameter sniffing

set statistics io on;

exec sp_executesql N'select * from [EXPORT].[vGfExpBP_TIT] where TitleId=  cast(@TitleId as varchar(12))

order by [key];',N'@TitleId nvarchar(12),@useInit nvarchar(1)',@TitleId=N'LU1569045039',@useInit=N'1'