We are trying to understand why our application built with PB2019R2 is significantly slower than the same application built with PB2017, even though in general the application is slow. Analysing the interaction with database using MSSQL Profiled we noticed there is a lot of queries following this pattern:
SET FMTONLY ON select cle_societe, cle_article from article_societe where 1=2 SET FMTONLY OFF
SET TEXTSIZE 32767
declare @p1 int set @p1=67872 exec sp_prepexec @p1 output,N'@P1 numeric(12,0),@P2 numeric(12,0)',N'select tourne_en_prod_soc from article_societe where cle_societe =@P1 and cle_article =@P2 ',2,2000095617 select @p1
SET TEXTSIZE 2147483647
exec sp_unprepare 67872
This pattern is repeated with a lot of different queries over and over and we are having a hard time understanding
where this comes from
Does anyone know where those queries come from? Each of them is usually fast but they add up to account
for 80-90% of the server time
Thanks
this makes sense indeed.