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.
Queries from SQL 2019 / 2022 do not show IO total operations
Re: Queries from SQL 2019 / 2022 do not show IO total operations
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.
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
Hi is there any update?
Re: Queries from SQL 2019 / 2022 do not show IO total operations
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.
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
Hi is there any further update?
Re: Queries from SQL 2019 / 2022 do not show IO total operations
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
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.