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.
The intellisense for Table or fields takes a long time to appear. For instance when I write 'SELECT * FROM CSDA' then I have to wait several seconds before the tables that start with CSDA appears.
Same issues with the WHERE which takes a long time to show the list of fields for the table. These need performance enhancements.
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: Yes
Preview Features: Enabled
Modes: Restricted
System Info
|Item|Value|
|---|---|
|CPUs|12th Gen Intel(R) Core(TM) i7-12700H (20 x 2688)|
|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 (20.72GB free)|
|Process Argv||
|Screen Reader|no|
|VM|0%|
Process Info
```
CPU % Mem MB PID Process
0 100 1960 azuredatastudio main
0 132 5532 extensionHost [1]
0 79 13484 electron-nodejs ("C:\Users\geard\AppData\Local\Programs\Azure Data Studio\azuredatastudio.exe" --ms-enable-electron-run-as-node "c:\Users\geard\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\json-language-features\server\dist\node\jsonServerMain" --node-ipc --clientProcessId=5532)
0 150 23828 "c:\Users\geard\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\mssql\sqltoolsservice\Windows\5.0.20240724.1\MicrosoftSqlToolsServiceLayer.exe" --application-name azuredatastudio --data-path C:\Users\geard\AppData\Roaming --locale en --log-file c:\Users\geard\AppData\Roaming\azuredatastudio\logs\20241016T011631\window1\exthost\Microsoft.mssql\sqltools.log --tracing-level All --autoflush-log --parallel-message-processing --parallel-message-processing-limit 100 --enable-sql-authentication-provider --enable-connection-pooling
0 11 9780 C:\WINDOWS\system32\conhost.exe 0x4
0 39 24176 "c:\Users\geard\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\mssql\sqltoolsservice\Windows\5.0.20240724.1\MicrosoftSqlToolsCredentials.exe" --application-name azuredatastudio --data-path C:\Users\geard\AppData\Roaming --locale en --log-file c:\Users\geard\AppData\Roaming\azuredatastudio\logs\20241016T011631\window1\exthost\Microsoft.mssql\credentialstore.log --tracing-level All --autoflush-log
0 11 1424 C:\WINDOWS\system32\conhost.exe 0x4
0 39 28072 "c:\Users\geard\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\mssql\sqltoolsservice\Windows\5.0.20240724.1\SqlToolsResourceProviderService.exe" --application-name azuredatastudio --data-path C:\Users\geard\AppData\Roaming --locale en --log-file c:\Users\geard\AppData\Roaming\azuredatastudio\logs\20241016T011631\window1\exthost\Microsoft.mssql\resourceprovider.log --tracing-level All --autoflush-log
0 11 25560 C:\WINDOWS\system32\conhost.exe 0x4
0 71 5568 fileWatcher [1]
0 39 6924 utility-network-service
0 86 24648 shared-process
0 91 25040 window [2] (Issue Reporter)
0 98 26416 gpu-process
0 232 27632 window [1] (● SQLQuery_1 - (199) Cloud - Azure Data Studio)
```
Workspace Info
```
;
```
Extensions (4)
Extension|Author (truncated)|Version
---|---|---
admin-tool-ext-win|Mic|0.1.3
import|Mic|1.6.1
profiler|Mic|0.14.0
schema-compare|Mic|1.21.0
Type: Performance Issue
The intellisense for Table or fields takes a long time to appear. For instance when I write 'SELECT * FROM CSDA' then I have to wait several seconds before the tables that start with CSDA appears.
Same issues with the WHERE which takes a long time to show the list of fields for the table. These need performance enhancements.
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: Yes Preview Features: Enabled Modes: Restricted
System Info
|Item|Value| |---|---| |CPUs|12th Gen Intel(R) Core(TM) i7-12700H (20 x 2688)| |GPU Status|2d_canvas: enabledcanvas_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 (20.72GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Process Info
``` CPU % Mem MB PID Process 0 100 1960 azuredatastudio main 0 132 5532 extensionHost [1] 0 79 13484 electron-nodejs ("C:\Users\geard\AppData\Local\Programs\Azure Data Studio\azuredatastudio.exe" --ms-enable-electron-run-as-node "c:\Users\geard\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\json-language-features\server\dist\node\jsonServerMain" --node-ipc --clientProcessId=5532) 0 150 23828 "c:\Users\geard\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\mssql\sqltoolsservice\Windows\5.0.20240724.1\MicrosoftSqlToolsServiceLayer.exe" --application-name azuredatastudio --data-path C:\Users\geard\AppData\Roaming --locale en --log-file c:\Users\geard\AppData\Roaming\azuredatastudio\logs\20241016T011631\window1\exthost\Microsoft.mssql\sqltools.log --tracing-level All --autoflush-log --parallel-message-processing --parallel-message-processing-limit 100 --enable-sql-authentication-provider --enable-connection-pooling 0 11 9780 C:\WINDOWS\system32\conhost.exe 0x4 0 39 24176 "c:\Users\geard\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\mssql\sqltoolsservice\Windows\5.0.20240724.1\MicrosoftSqlToolsCredentials.exe" --application-name azuredatastudio --data-path C:\Users\geard\AppData\Roaming --locale en --log-file c:\Users\geard\AppData\Roaming\azuredatastudio\logs\20241016T011631\window1\exthost\Microsoft.mssql\credentialstore.log --tracing-level All --autoflush-log 0 11 1424 C:\WINDOWS\system32\conhost.exe 0x4 0 39 28072 "c:\Users\geard\AppData\Local\Programs\Azure Data Studio\resources\app\extensions\mssql\sqltoolsservice\Windows\5.0.20240724.1\SqlToolsResourceProviderService.exe" --application-name azuredatastudio --data-path C:\Users\geard\AppData\Roaming --locale en --log-file c:\Users\geard\AppData\Roaming\azuredatastudio\logs\20241016T011631\window1\exthost\Microsoft.mssql\resourceprovider.log --tracing-level All --autoflush-log 0 11 25560 C:\WINDOWS\system32\conhost.exe 0x4 0 71 5568 fileWatcher [1] 0 39 6924 utility-network-service 0 86 24648 shared-process 0 91 25040 window [2] (Issue Reporter) 0 98 26416 gpu-process 0 232 27632 window [1] (● SQLQuery_1 - (199) Cloud - Azure Data Studio) ```Workspace Info
``` ; ```Extensions (4)
Extension|Author (truncated)|Version ---|---|--- admin-tool-ext-win|Mic|0.1.3 import|Mic|1.6.1 profiler|Mic|0.14.0 schema-compare|Mic|1.21.0