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

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
brendang
Posts: 3
Joined: Sat 08 Oct 2022 02:04

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

Post by brendang » Sat 08 Oct 2022 02:25

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

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

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

Post by dzhanhira » Tue 11 Oct 2022 10:24

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.

brendang
Posts: 3
Joined: Sat 08 Oct 2022 02:04

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

Post by brendang » Sat 15 Oct 2022 06:20

Hi is there any update?

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

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

Post by dzhanhira » Mon 17 Oct 2022 10:08

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.

brendang
Posts: 3
Joined: Sat 08 Oct 2022 02:04

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

Post by brendang » Mon 24 Oct 2022 02:46

Hi is there any further update?

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

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

Post by dzhanhira » Tue 25 Oct 2022 10:50

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.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

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

Post by dzhanhira » Tue 25 Oct 2022 12:46

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.

Post Reply