microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 908 forks source link

Query Plan Viewer is not available #25951

Open HenryJartu opened 1 month ago

HenryJartu commented 1 month ago

Type: Bug

I have clicked on Enable Actual Plan but when I execute a query only 2 tabs are shown, Results and Messages

Azure Data Studio version: azuredatastudio 1.49.1 (2f696aa95a13ccabd7e0a4431d1d759e3a7b8cfd, 2024-08-13T18:12:38.831Z) OS version: Windows_NT x64 10.0.22631 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|13th Gen Intel(R) Core(TM) i7-1355U (12 x 2611)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|31.69GB (13.42GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (5) Extension|Author (truncated)|Version ---|---|--- dacpac|Mic|1.14.0 import|Mic|1.6.1 profiler|Mic|0.14.0 schema-compare|Mic|1.21.0 powershell|ms-|2024.3.2 ![Screenshot 2024-10-07 132757](https://github.com/user-attachments/assets/410d9d2f-dc18-4c59-abfe-89fcc46efa98)
kburtram commented 1 month ago

@HenryJartu I wasn't able to reproduce this issue in the environment/build you listed. Do you have any additional details, such as an error in the log (I'll add a tag to request logs in case there is an error there), or a particular type of query you're using for this to occur? Please also verify the button says "Disable Actual Plan", meaning the actual plan is currently enabled?

image

github-actions[bot] commented 1 month ago

We need more info to debug your particular issue. If you could attach your logs to the issue (ensure no private data is in them), it would help us fix the issue much faster.

  1. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart Azure Data Studio.
  2. Open command palette (Click View -> Command Palette) and run the command Developer: Set Log Level... and set the level to Trace.
  3. Run the repro scenarios.
  4. Collect the following logs:

    Console Logs

    • Open Developer Tools (Help -> Toggle Developer Tools)
    • Click the Console tab
    • Click in the log area and select all text (CTRL+A)
    • Save this text into a file named console.log and attach it to this issue.
    • Developer Tools can be closed via Help -> Toggle Developer Tools

    Application Logs

    • Open command palette (Click View -> Command Palette)
    • Run the command: Developer: Open Logs Folder
    • This will open the log folder locally. Please zip up this folder and attach it to the issue.
  5. Now you can revert the Log/Tracing levels changes made in step 1 and step 2.
HenryJartu commented 1 month ago

See attached requested files

Henry Jartu Sr. Director, Data Warehouse Mobile: 561.318.9384 Reveleer.comhttps://www.reveleer.com | LinkedInhttps://www.linkedin.com/company/19205981 [data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAiYAAADZCAYAAAAUlfujAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFxEAABcRAcom8z8AAP+lSURBVHhe7L0FgB1XcjWc/wvtJptks0kWTLJkGSWDLGZmBouZmZkli8FispjJFpOFFjMzM8+DYXjd7/x1ql/PvBnNSCN5ZEi6pJqmy92v63Tdqrp/B4cccsghhxxyyKFfCTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxz66eT3K1v/ZFf/kqwjhxxKLaUMTEwD/rhYmLExMGOi4VeOiWfI+dfOrOcn1OVP5lyq+FXr/LnG5XXzy/bjJ96nF/LPPa4p9CfZZ/8FbdNnMIXyEnFq0qTAKf0ef8pv9afkDeZX/g0GM9sR3Jakx2nBr1gH+2dz/PmU8r2ozOdcS3o/dN/moHQvxcFlvKgsuRbfBuVo67wvDn7TFNhhJgATP49teEJ6RWBiiAzyeOG/cRv+C5fhv3gF/ktXHf6t8kXh83Ifr1yH/0mIPD9xgRv9LCUPTPhgeULgu34RcaePIu74QeFD8J08EsRHAxx87tfHRoCTuxbMqUmTlvxz1/db5rQaq9Q+Cy/iX8u9S6v+pDXb7XpdbXsdZadFmXYZr6NtKZ1P67rILyrXOHEYBuXBmRMwbl+HEeaW79g4QhOYxCYCVChDEsDIqwETvzcU5qZtMFp1g1GsGswytWCWqwuzvMO/SS5bB0aRKvDVbA5j3jKY9x/KTU7+uUgWmPgFBfsunUb0ynmI+OZrRAzphchhfRA5sh8iRw1Qjho9MMDc7x/gfmnLo4I4uesv4MggTu56ivyK9b1Mvpdu08/JL9v/n3CPUsVpVHaqn4UU+hMp58iJzr+gbVpfCuUl4tSkScJ2f55pU4CTbW8q+afkDeZUjfeLmO0IbkvS4zTgZ/qbyjri7wGP7Twp5XtRmc+5lrR99nGiNr8sM29y/Jy0WueIPoga0hPRE0cidtMqxN28AiMmEobIjuSBCekVgIl8VRvT58HIlA/G3/0bzL/7H5h//zeY//iGw79F/n9/lfv4r/D914fw9RoC88p1uckvA0xiYxC7+wdE9OsAb+Ui8BTOBk+xHPCWyglvmdwILZNHOG+Auc9zuYRz/qrYG8TJXQ/m1KRJS/656/stc1qNVWqfhRfxy5ThLZv8+bRguz8pted5117EaZH3VfO/iF9H2a9app0vKSeX9lU5uTJfd11Jyw2z90uLHCiRFd5CXyC0RhlEjRuKuBOHYESEWcCE8kOndLiXFJy8HPlDXDBnL4Y/Rwngn/4G/Ht64D8zAn963+HfIv/xPfj//q8w030JY+BomFdv8GEJ3O3ElPxUTkw0YresQXjLOnDn+BAhGf+MkA//Clemv8H92RvCb8L96VvCbweY+3L+U7melvxZECd3/QXsCuLkrgdzatKkJf/c9f2WOa3GKrXPwoueuZdpj+snPsPPY7s/KbWHdWv9yVx7Ef+kvEGc3PWfxm9IueTkrr06v2p77XzKgTF71XFLie2yg5+hNKkraV67TNknB1/z2PuZ/gLXh/8FV/o/wp3/c4T374KYg7tghHusqRxhlTX6h1CF/GrgRIHJ3KXw5ykN/MvblnD7n4+AP3/s8G+R//tD+P/5LZjv5YAxeCzMazdfEpjExsK3dyciB3SHt3oZuEvkhrt0HnjK5YW3Qj7h/PCWLyBcMIh5zPOvzp6k51iPzUmv/cqYbX+m/b8RTtr2X1tffva2BD1zyY3FS7Xnl3yGf0K9HslHTu5aatkeu5carxdyASmPnNy1tOPUtttOpxwYs586bsnxM+Vy3+agdC/FSfLGt5/7QefJofZ+WXn/l8oFT5Hs8NSugPCJwxFz6gCMCO+vE5j85ZOUObn0Dr8+/snAxDAk0xXEblyDyNlTETFpNCKmjEbkNOHpYxA1fSyip38jPC6IefzqHCUcGdgGn7M5OO2L+FXzpZaTls8t2x7c/qRp0pKDy/6p5TN/cNuTHieX52XYLvOnlJVSGSmd/6kcXG7SsbE5uXzJcWrypCZNchyfb9rzryd37XnMPEn7nVy6F3HScpJL87Ks7ZH+KgeOk0uXEtt5nsnHMQyMI6+ltt3B5QXzi9I+71xyzOvB9yOYk0ufGk5aTnCfycmmnTYWUZQFE0YgYu5URP24CbF3r8KIiVD4oWwZmshePFQRfnn6ScCE6UQQ4r8+sPL9ZxDzmOd53dHA/Hz8k4GJJPZHRsJ88hhxd28j7tZ1xN2+Dh8tsO+Qb8C8c1OYW3v/p7ERxM87lxp+1Xyp5aTlBx8ndy44b/L8cuMYXHbqyrfZriehvqRlJeVny3g5TouyUiojpfPJc+J+P4+Dy02Jk8uXHKcmz4vTJN/m+Hy3n70WfD25a89jK9+NAL9aGWQ7b+Iygu/Di++FxQlptSzpr3Hbbl9qy7A4xfZIeWZgHIPTJKRLnpOmtflFaZ93LjkOTpeUk0ufGk6urGBONi3HXdgnMsF39yZ8rocwor0wjRiYAkZMyg7ZJrgLB/PL0SsDE6Zh2n/PAPxe8v3TG8A//E34r9b2H+WY52mz8jJgx+Gfxj8ZmAglfaSSz+6QQw455ND/JUoqF0wYwj6YpmwZ0yQRMCHZKV+OXgqYcGqG16gR+cO7Cjr8f/kY/ow54P+8EPzZS8CfqxT8OUrC/0Vh+N/PCf9fM1ng5d8kPY1q/zcDFFt7RP6l+ukAE4cccsghh9KSbDlgT84kMMOrWdoSW2OScJUUvJ96eilgwvMUuv/xniUAP8oDo0xNGB36wBg7FcacpTAWfWfFzxg/A2aX/jAq1IWZKR/8zP9Hyfe/UXtij4tOY9Gj6TcOTOIfJvuZCmaHHHLIIYf+T1FyYsDWjFj/7Gv21Z9GqQImfwlsVfORHua7X8KsWA/myEkw122Befw0/Lfvwe/ywB8WDr/bC//d+/CfPAtz83YY46bDqNkM5gc5LM1JANgkquM3yzJWfxQw8q/prLGRc+Zbn8P/RmZrHH9ugJI2wMQhhxxyyCGHUiYbjART2sCSVAITHvM8p24+yAWjcQeYK9fCfPj4he3gdVMAi7FhK4wOveD/soilPUlLzQnL+W/yTzC01TIC+VNbhqb7CP53vpB+FYVZrg6M6s1glKiu46R9pCYlubyvix1g4pBDDjnk0G+ZUgVMqBH4j/dE2GWH0aILzJ174Q8Niwcl3PqjomE+eAjz+k2Y9+7DHxmV6LoZEQnzxBkY/YbD/KIQ/PbUhw0EErHUae8TLKQEOOw0LIvttoHAywCU55YRdD2eA/l4/T8zwi/nzMKVYIyYCGP3QRmbfTD6j1QAhn99x9IO/flndJuWdjnAxCGHHHLIod8svRCYUBPxh/Tw/zUzjNotYWzZAURHW3mFzbv3Yf6wC+aUOTAHjITZc7BsR8Cc+C3MTdvhv3knHqDQKsb4YSeMyg3g/1tma2qIIODf0gP/+Df4/0HY9uThlM+/iGAnExjZbbJjozDfH9IBv3vL8v6hMS7zBJ8jKAjuS1JmXzkFw/Ss598D+Zn393LMdv3ruyLo37TaJlv8h7SZZdJeRs6Z/5JOp6mMg8csuyBqh8bNgPlxHvj/7t+Av/+r1dbk6n8d7AAThxxyyCGHfsv0XGCiAjgj/H/6AGbecjBmL4HpDbUyMg7X1Rswps2DUb2JpQV590trWiNDVpif5oNZtSGMiTNhnruk+cxHj2EsWgGjUn343/rMEvz/I4L0zc/gTy95MmSz7DNYr7Ce+zgv8F524I1P5ZwleNXAlKHXmUbyqAdQvnLwFygPf66S8H8idb/5qbRb+kIAYWs/bFCjZVjX/H/+xPIeyl4c/oKSP29Z+D+Tvrwt/RBQZsp1M10Wq2]https://www.reveleer.com/rise-west-2024

IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Reveleer may contain information that is confidential and legally privileged. Please do not read, copy, forward, or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it to the sender and delete it completely from your computer system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.


From: github-actions[bot] @.> Sent: Monday, October 7, 2024 6:46 PM To: microsoft/azuredatastudio @.> Cc: Henry Jartu @.>; Mention @.> Subject: Re: [microsoft/azuredatastudio] Query Plan Viewer is not available (Issue #25951)

You don't often get email from @.*** Learn why this is important We need more info to debug your particular issue. If you could attach your logs to the issue (ensure no private data is in them), it would help us fix the issue much faster. First open the Settin ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ [https://image-processing-service.us-1.mimecastcybergraph.com/v2/banners?e=lTQjcz40acCQJkDWzNl3c-m8OEDnlG3yFwAkVG_oyBBuF3eCsGdan4DAlyCapZj8upcSOFbxqysPN4R_fljmxi19zOYx7xgr9NrtvHlOnL1zbDWzvo7tdAfqA9QA063vmnku01KBi_FdDL2EGC1jSf_PdVO_f92_bcXDa18U6hr71-vpGIHNrtDNwM057zTl_MiNNYEJ10bk83o7hrCE89mgW_RfqFl4O8bCIf7aANdETF3g1NGgmXkuBoN_v4GbqVgb6ftkIPEiws8ge3Vvo3Be3bIDzRYPVnBgyfXVhBRbfV7qP0WIx5komdGWtQZ7i6EMFZbIvDUn32Y8jwN3yKauIc74BEsK4zHCQo84L0BlrVmH9YD40ovK4shWzKqa5GXgWEh823CwiYF7Az6VfcfRbA==]https://report.mimecastcybergraph.com/?magiclink=https%3A%2F%2Fapi.services.mimecast.com%2Foauth2%2Fauthorize%3Fresponse_type%3Dcode%26client_id%3Do20nRkVXf7VUVnANkXhoOwGytEwGN0YAlyeDJn7oBTGNl2kN%26state%3DeyJhbGciOiJSU0EtT0FFUC0yNTYiLCJlbmMiOiJBMjU2R0NNIn0.A1RjkI7-NYAdULy5Chfu2r0fO3oAU_beO7tsPhT080PkvQq34rrwoYbrzS2jcWTCSHzka7a2lKTJCxyXqfb7mIyLQJSn5qF2442vpyBfKD0zKO0gH7Cej7d8vHYBxy2tW8w1DJOExQuJN0NAcJSQM_vUHZzNrkgbvz5W9BT3QNUlISp10TTijjg9Z04Q1NE3BAEboUMX9axpNcUmGe2CmrYykZzT7PxIahShgI-kCTVIwAoRgCu1SSzxo5BbsHYAcDbwZ8sCNlon5QwIuTd2g-NmikShy2ayqbepOxXszmOIRUNzY1czG57IK1zdowkruuOczJ93nO1Rzq2A_Pk0tA.5CPpWa_LFeAEwqy4.A_N20XVkTvOgADnEs7aC_dVaSSBs68GZ_TdKQn5Fd_no18pZ3R6kYhj6s3-NPWo11S1R1hthRtobaNXFYAOwLJJrEtv-pslIDoC6o4s9xbsa9VDyZgY_Thc8jaTeJuCJJTOVhGURF2SyhSLy__7Eh9-3SlwJlIU-UUtsf6wW5Z_StmAgiSGbnfIER2PbYVUlC7Q_YLl0ND6HGiSfOcpVu326bq4TCYyrRYZUH6S4wm1n1wvOBSohPI3Y-lzV3HCFH2K9BP5SalJUW_OCNKLWfTLpZ_a03x9ohooJPWGmyTx9D1oxMBSyePUSxMzCNrsv-JYNKAlQ16oHMsD5vSQ-0DcN2ReBhw-S6Ex-I2eGCFtU5x-_6saA6mb61g4lNwABA0OQNt0u4KsyGloiUjczogg3OpaU35YplYnHLNbQ9Dpc-7XeQmNe0xr084ny1jHkWWAboGz1-v8yYGsS9v8b1Z3m6FyzvrWfBYzO90i2vIOSvdpCVkIXxfIVuNr4xughnlOt40fSXQf4ki4a68IZF6MmQFqHjq9QTh3kLm3q4lhSNeA9LXOpyItfmCP2JJpYsJdt1R1opC1_HIk5uYsQegcwiBP3VngusQ0qFQjmqtiuE6eXaVAw0L5_L9MyP9__CSqMq3xzEtudyuf1aIYTTDlQN3P_ZioNvvQazCrnHICdpHQs9XgbITlZgkavUR29WK0BS0j0azVP6qL-BufUK8y2bX8or9z31feMfXxGyx7JB8n_rWMNNh1CL9qa-Wf41t4SlfJ-aBxSiZ9gmsiGJ9RMcCmkTvo6MtVKqTiQFHuLm6Rk0Y2hqxzHz08Xc0TfB54G2PQ4FK-WV6infdyhVFdCE8jPKylzvNWSDIupwEdSw5yWHfn41f8BvY2yIZQNegf9WyzJNjP4k9oSwdcJKteZQS_-IQI.Cd1LNSD1n3BEEAgq2gDI-A%26redirect_uri%3Dhttps%3A%2F%2Freport.mimecastcybergraph.com%2Fcallback CGBANNERINDICATOR

You don't often get email from @.*** Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification

We need more info to debug your particular issue. If you could attach your logs to the issue (ensure no private data is in them), it would help us fix the issue much faster.

  1. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart Azure Data Studio.
  2. Open command palette (Click View -> Command Palette) and run the command Developer: Set Log Level... and set the level to Trace.
  3. Run the repro scenarios.
  4. Collect the following logs:

Console Logs

Application Logs

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/25951#issuecomment-2398056651, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A256J7QPTB43S4ZFOZ4KQRTZ2MFMZAVCNFSM6AAAAABPQNVL6WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGOJYGA2TMNRVGE. You are receiving this because you were mentioned.Message ID: @.***>

kburtram commented 3 weeks ago

Unfortunately the content provide is being displayed as encoded base64 text. Please let me know if you still require assistance for this issue, and if you can provide more details how to reproduce the issue. Thanks!

HenryJartu commented 3 weeks ago

Yes, I still need assistance. When I go against a regular SQL Server or an AWS RDS for SQL Server the query plan viewer works and or is shown. However, when I go against Azure Synapse Analytics (Dedicated SQL Pool..formerly Azure SQL Datawarehouse database object it is not available and no error messages. See screenshots of execution behavior comparison between the two types of SQL Servers.

Azure Synapse Analytics (Dedicated SQL Pool..formerly Azure SQL Datawarehouse [cid:dbe92841-c9a2-4e2c-b415-4ef7bb612f51]

NONE azure dedicated SQL Pool

[cid:2b252117-17cb-4cf0-8c5f-b4020c6167b8]

Henry Jartu Sr. Director, Data Warehouse Mobile: 561.318.9384 Reveleer.comhttps://www.reveleer.com | LinkedInhttps://www.linkedin.com/company/19205981 [data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAiYAAADZCAYAAAAUlfujAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFxEAABcRAcom8z8AAP+lSURBVHhe7L0FgB1XcjWc/wvtJptks0kWTLJkGSWDLGZmBouZmZkli8FispjJFpOFFjMzM8+DYXjd7/x1ql/PvBnNSCN5ZEi6pJqmy92v63Tdqrp/B4cccsghhxxyyKFfCTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxxyyKFfDTnAxCGHHHLIIYcc+tWQA0wccsghhxz66eT3K1v/ZFf/kqwjhxxKLaUMTEwD/rhYmLExMGOi4VeOiWfI+dfOrOcn1OVP5lyq+FXr/LnG5XXzy/bjJ96nF/LPPa4p9CfZZ/8FbdNnMIXyEnFq0qTAKf0ef8pv9afkDeZX/g0GM9sR3Jakx2nBr1gH+2dz/PmU8r2ozOdcS3o/dN/moHQvxcFlvKgsuRbfBuVo67wvDn7TFNhhJgATP49teEJ6RWBiiAzyeOG/cRv+C5fhv3gF/ktXHf6t8kXh83Ifr1yH/0mIPD9xgRv9LCUPTPhgeULgu34RcaePIu74QeFD8J08EsRHAxx87tfHRoCTuxbMqUmTlvxz1/db5rQaq9Q+Cy/iX8u9S6v+pDXb7XpdbXsdZadFmXYZr6NtKZ1P67rILyrXOHEYBuXBmRMwbl+HEeaW79g4QhOYxCYCVChDEsDIqwETvzcU5qZtMFp1g1GsGswytWCWqwuzvMO/SS5bB0aRKvDVbA5j3jKY9x/KTU7+uUgWmPgFBfsunUb0ynmI+OZrRAzphchhfRA5sh8iRw1Qjho9MMDc7x/gfmnLo4I4uesv4MggTu56ivyK9b1Mvpdu08/JL9v/n3CPUsVpVHaqn4UU+hMp58iJzr+gbVpfCuUl4tSkScJ2f55pU4CTbW8q+afkDeZUjfeLmO0IbkvS4zTgZ/qbyjri7wGP7Twp5XtRmc+5lrR99nGiNr8sM29y/Jy0WueIPoga0hPRE0cidtMqxN28AiMmEobIjuSBCekVgIl8VRvT58HIlA/G3/0bzL/7H5h//zeY//iGw79F/n9/lfv4r/D914fw9RoC88p1uckvA0xiYxC7+wdE9OsAb+Ui8BTOBk+xHPCWyglvmdwILZNHOG+Auc9zuYRz/qrYG8TJXQ/m1KRJS/656/stc1qNVWqfhRfxy5ThLZv8+bRguz8pted5117EaZH3VfO/iF9H2a9app0vKSeX9lU5uTJfd11Jyw2z90uLHCiRFd5CXyC0RhlEjRuKuBOHYESEWcCE8kOndLiXFJy8HPlDXDBnL4Y/Rwngn/4G/Ht64D8zAn963+HfIv/xPfj//q8w030JY+BomFdv8GEJ3O3ElPxUTkw0YresQXjLOnDn+BAhGf+MkA//Clemv8H92RvCb8L96VvCbweY+3L+U7melvxZECd3/QXsCuLkrgdzatKkJf/c9f2WOa3GKrXPwoueuZdpj+snPsPPY7s/KbWHdWv9yVx7Ef+kvEGc3PWfxm9IueTkrr06v2p77XzKgTF71XFLie2yg5+hNKkraV67TNknB1/z2PuZ/gLXh/8FV/o/wp3/c4T374KYg7tghHusqRxhlTX6h1CF/GrgRIHJ3KXw5ykN/MvblnD7n4+AP3/s8G+R//tD+P/5LZjv5YAxeCzMazdfEpjExsK3dyciB3SHt3oZuEvkhrt0HnjK5YW3Qj7h/PCWLyBcMIh5zPOvzp6k51iPzUmv/cqYbX+m/b8RTtr2X1tffva2BD1zyY3FS7Xnl3yGf0K9HslHTu5aatkeu5carxdyASmPnNy1tOPUtttOpxwYs586bsnxM+Vy3+agdC/FSfLGt5/7QefJofZ+WXn/l8oFT5Hs8NSugPCJwxFz6gCMCO+vE5j85ZOUObn0Dr8+/snAxDAk0xXEblyDyNlTETFpNCKmjEbkNOHpYxA1fSyip38jPC6IefzqHCUcGdgGn7M5OO2L+FXzpZaTls8t2x7c/qRp0pKDy/6p5TN/cNuTHieX52XYLvOnlJVSGSmd/6kcXG7SsbE5uXzJcWrypCZNchyfb9rzryd37XnMPEn7nVy6F3HScpJL87Ks7ZH+KgeOk0uXEtt5nsnHMQyMI6+ltt3B5QXzi9I+71xyzOvB9yOYk0ufGk5aTnCfycmmnTYWUZQFE0YgYu5URP24CbF3r8KIiVD4oWwZmshePFQRfnn6ScCE6UQQ4r8+sPL9ZxDzmOd53dHA/Hz8k4GJJPZHRsJ88hhxd28j7tZ1xN2+Dh8tsO+Qb8C8c1OYW3v/p7ERxM87lxp+1Xyp5aTlBx8ndy44b/L8cuMYXHbqyrfZriehvqRlJeVny3g5TouyUiojpfPJc+J+P4+Dy02Jk8uXHKcmz4vTJN/m+Hy3n70WfD25a89jK9+NAL9aGWQ7b+Iygu/Di++FxQlptSzpr3Hbbl9qy7A4xfZIeWZgHIPTJKRLnpOmtflFaZ93LjkOTpeUk0ufGk6urGBONi3HXdgnMsF39yZ8rocwor0wjRiYAkZMyg7ZJrgLB/PL0SsDE6Zh2n/PAPxe8v3TG8A//E34r9b2H+WY52mz8jJgx+Gfxj8ZmAglfaSSz+6QQw455ND/JUoqF0wYwj6YpmwZ0yQRMCHZKV+OXgqYcGqG16gR+cO7Cjr8f/kY/ow54P+8EPzZS8CfqxT8OUrC/0Vh+N/PCf9fM1ng5d8kPY1q/zcDFFt7RP6l+ukAE4cccsghh9KSbDlgT84kMMOrWdoSW2OScJUUvJ96eilgwvMUuv/xniUAP8oDo0xNGB36wBg7FcacpTAWfWfFzxg/A2aX/jAq1IWZKR/8zP9Hyfe/UXtij4tOY9Gj6TcOTOIfJvuZCmaHHHLIIYf+T1FyYsDWjFj/7Gv21Z9GqQImfwlsVfORHua7X8KsWA/myEkw122Befw0/Lfvwe/ywB8WDr/bC//d+/CfPAtz83YY46bDqNkM5gc5LM1JANgkquM3yzJWfxQw8q/prLGRc+Zbn8P/RmZrHH9ugJI2wMQhhxxyyCGHUiYbjART2sCSVAITHvM8p24+yAWjcQeYK9fCfPj4he3gdVMAi7FhK4wOveD/soilPUlLzQnL+W/yTzC01TIC+VNbhqb7CP53vpB+FYVZrg6M6s1glKiu46R9pCYlubyvix1g4pBDDjnk0G+ZUgVMqBH4j/dE2GWH0aILzJ174Q8Niwcl3PqjomE+eAjz+k2Y9+7DHxmV6LoZEQnzxBkY/YbD/KIQ/PbUhw0EErHUae8TLKQEOOw0LIvttoHAywCU55YRdD2eA/l4/T8zwi/nzMKVYIyYCGP3QRmbfTD6j1QAhn99x9IO/flndJuWdjnAxCGHHHLIod8svRCYUBPxh/Tw/zUzjNotYWzZAURHW3mFzbv3Yf6wC+aUOTAHjITZc7BsR8Cc+C3MTdvhv3knHqDQKsb4YSeMyg3g/1tma2qIIODf0gP/+Df4/0HY9uThlM+/iGAnExjZbbJjozDfH9IBv3vL8v6hMS7zBJ8jKAjuS1JmXzkFw/Ss598D+Zn393LMdv3ruyLo37TaJlv8h7SZZdJeRs6Z/5JOp6mMg8csuyBqh8bNgPlxHvj/7t+Av/+r1dbk6n8d7AAThxxyyCGHfsv0XGCiAjgj/H/6AGbecjBmL4HpDbUyMg7X1Rswps2DUb2JpQV590trWiNDVpif5oNZtSGMiTNhnruk+cxHj2EsWgGjUn343/rMEvz/I4L0zc/gTy95MmSz7DNYr7Ce+zgv8F524I1P5ZwleNXAlKHXmUbyqAdQvnLwFygPf66S8H8idb/5qbRb+kIAYWs/bFCjZVjX/H/+xPIeyl4c/oKSP29Z+D+Tvrwt/RBQZsp1M10Wq2]https://www.reveleer.com/rise-west-2024

IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Reveleer may contain information that is confidential and legally privileged. Please do not read, copy, forward, or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it to the sender and delete it completely from your computer system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.


From: Karl Burtram @.> Sent: Tuesday, October 29, 2024 4:51 PM To: microsoft/azuredatastudio @.> Cc: Henry Jartu @.>; Mention @.> Subject: Re: [microsoft/azuredatastudio] Query Plan Viewer is not available (Issue #25951)

You don't often get email from @.*** Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification

Unfortunately the content provide is being displayed as encoded base64 text. Please let me know if you still require assistance for this issue, and if you can provide more details how to reproduce the issue. Thanks!

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/25951#issuecomment-2445305274, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A256J7QD32QUKHS6RGF4HKLZ57YL7AVCNFSM6AAAAABPQNVL6WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINBVGMYDKMRXGQ. You are receiving this because you were mentioned.