Page 1 of 1

Queries from SQL 2019 / 2022 do not show IO total operations

Posted: Sat 08 Oct 2022 02:25
by brendang
I have Devart 6.3.9 Sql Studio

Given 2 queries run on 2 servers (Sql 2016 Compat 130) and (Sql 2019 Compat 150), only the 2016 version shows the total table IO in query profiling mode, however the same query when run on a copy of the database on the 2019 server does not show the total table IO. However when comparing the RAW xml from the 2 plans they both clearly show the table IO results. Is this a bug?

Plan #1 - 2016 Server - Shows correctly in DBForge > https://www.brentozar.com/pastetheplan/?id=rJLzpL0zs

Plan #2 - 2019 Server - Does not show correctly > https://www.brentozar.com/pastetheplan/?id=rJIwkPCGj

Update: 10/10/2022 - does not show IO for SQL 2022 Preview 3 either.

Image

Re: Queries from SQL 2019 / 2022 do not show IO total operations

Posted: Tue 11 Oct 2022 10:24
by dzhanhira
Hi,

Thanks for contacting us!

Kindly be informed that we are investigating this behavior

and once there is an update, we will let you know.

Re: Queries from SQL 2019 / 2022 do not show IO total operations

Posted: Sat 15 Oct 2022 06:20
by brendang
Hi is there any update?

Re: Queries from SQL 2019 / 2022 do not show IO total operations

Posted: Mon 17 Oct 2022 10:08
by dzhanhira
Hi Brendan,

Kindly be informed that we have confirmed that it's a bug. Your ticket is converted to a bug report.

The issue is still investigating.

Once there is an update, we will inform you.

Re: Queries from SQL 2019 / 2022 do not show IO total operations

Posted: Mon 24 Oct 2022 02:46
by brendang
Hi is there any further update?

Re: Queries from SQL 2019 / 2022 do not show IO total operations

Posted: Tue 25 Oct 2022 10:50
by dzhanhira
Kindly note that at the moment we do not have an exact date for the fixe date however I want to assure you that our technical team is working on this ticket.

Re: Queries from SQL 2019 / 2022 do not show IO total operations

Posted: Tue 25 Oct 2022 12:46
by dzhanhira
Please, be informed that our team has decided to provide you with a special custom build. Once the build is ready, we will inform you.