Azuredatastudio: Application is too slow in general

[mbedded]

Issue Type: Bug

• Missing Intellisense for tables/columns
• "select top 1000 rows" needs 10 seconds to create a tab and execute the quers
• Overall very slow reaction times. Many actions need a lot of more time than in MSSQL-Management Studio

Azure Data Studio version: azuredatastudio 1.0.0 (cab8f3e37c9ac4367e0dacef5185da08bd8021c2, 2018-09-20T22:04:35.897Z)
OS version: Windows_NT x64 10.0.16299

System Info

|Item|Value|
|---|---|
|CPUs|Intel(R) Core(TM) i5-7360U CPU @ 2.30GHz (4 x 2304)|
|GPU Status|2d_canvas: enabled
checker_imaging: disabled_off
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
native_gpu_memory_buffers: disabled_software
rasterization: enabled
video_decode: enabled
video_encode: enabled
webgl: enabled
webgl2: enabled|
|Memory (System)|7.87GB (1.08GB free)|
|Process Argv|C:Program FilesAzure Data Studioazuredatastudio.exe|
|Screen Reader|no|
|VM|0%|

Extensions: none

[kburtram]

@mbedded do you have any additional details on your scenario? For example, are you querying tables with BLOB or other large columns?

[mbedded]

Hello @kburtram thanks to remind me of some missing information :)

I tested it with several tables. Noone of them had BLOBs. Just "normal" types like varchar(max), varchar(200), int, decimals..

Some tables had around 5 columns. The biggest one had ~40. The biggest table had around 100 rows. For me there was no difference between tables with none/few/many rows or columns.

The word "slow" here is compared to MSSQL-Management Studio. There i can click "select top 1000 rows" and i have the result in let's say in 1 second. I used Azure Data Studio and MSSQL-Management Studio for the same database in parallel (both were connected at same time).

I am not sure if i can enable some tracing. Maybe there is some time-tracking so i can send you a log which action is generating the 10-second delay.

EDIT:
The Server is a SQL-Server 2016

EDIT2:
I re-verified my reported issues. Now i have ~1GB more fre RAM (6 of 8 GB used). The query "select top 1000 rows" is now instant resolved as in Management Studio. I am not sure what was wrong this day.
I guess the "performance" part has been resolved by itself 😄

Addition to "intellisense is missing":

• When i execute "use MyDB" in a query window and then run any additional queries i have intellisense
• When i use "select top 1000 rows" (right click on a table of my database) i have no intellisense in that query window. The application should know which database and table i have queried with my right-click action

Maybe i should learn to use a tool 2-3 times till i report an issue. Sorry for the inconvenience i may have created :/

[Poltergeisen]

I'm having an issue with a query that is 5mb in size. It was a generated data extract script from someone with SSMS. It completely lagged out my window and the script wouldn't run.

[aaronsmith1234]

I'm also having issues, simple queries can take a long time to run

[git-xbits]

I'm also having problems with connection (pre-login), error with connection in new Query tab and after error with slow connection.

In MSSMS 18 or before runs perfectly.

[mbedded]

For the "new-posters": Could you add your current version pls and system information? My ticket is from Oct 2018 with "azuredatastudio 1.0.0".

My issue was resolved by a restart and didn't occurred once since them. I guess the software or my pc had just a bad day. I just left it open because of the "intellisense" part. Maybe (because we have two different issues here) we should split it into two separate tickets.

Greets

[git-xbits]

Same here, 2 day to now I have not any issue. I don't know why ahhaha

[pnhughes]

Version details appear at bottom of post.

I experience typing lag from 1 - 3 seconds in both text and code blocks when using notebooks in the application. Lag starts to appear after notebooks have grown sufficiently but I cannot identify a size threshold at present. Current notebook is 6 text blocks and 7 code blocks, with all output cleared. 14,260 bytes total for the file, 1,942 words, 89 lines. Typing lag has just started.

EDIT: Updated to include detail that application performance is resolved after closing & reopening Azure Data Studio.

Query performance does not appear to be affected, and I have had no performance issues, even with larger queries.

Happy to perform additional testing if anyone has any direction/suggestions.

ADS info:
Version: 1.9.0 (user setup)
Commit: 78a42e1d112ae3231777722b51eaf44f83ddbe55
Date: 2019-07-10T04:31:36.998Z
VS Code 1.34.0
Electron: 3.1.8
Chrome: 66.0.3359.181
Node.js: 10.2.0
V8: 6.6.346.32

System Info:
Surface Pro 6
Intel Core i5-8350 CPU @ 1.70 GHz
8 GB RAM
OS: Windows_NT x64 10.0.17763

[nioertel]

Similar issue here.
Connecting to a server takes around 60 seconds (simple SQL Server auth).
Executing a query takes even longer. Query window appears after 30 seconds (SELECT TOP 1000), execution and loading of the results takes at least another 30 seconds.
I tested with simple table (15 columns; 18 rows; data types: int, bigint, varchar, nvarchar, datetime).

Version: 1.15.1
Commit: 83544eba2504f564d785534cc780d2073feec2cc
Date: 2020-02-15T05:01:39.777Z
VS Code: 1.42.0
Electron: 6.1.6
Chrome: 76.0.3809.146
Node.js: 12.4.0
V8: 7.6.303.31-electron.0
OS: Darwin x64 18.7.0

I'm using a Macbook Pro (15" 2018; 2,2 GHz Intel Core i7; 32 GB 2400 MHz DDR4).

Edit:
Once I got the query results, I can execute any other query (also on other tables) from within the same query window and it finishes instantly.
If I query other databases however, I have to wait again for up to one minute.
The same happens if I try to open a database in the connections menu on the left within an already open connection. And then again if I want to see the tables inside the database.

[kasbert]

Disabling Settings / Application / Telemetry made a big difference for me.

[ponchautf]

Disabling Settings / Application / Telemetry made a big difference for me.

Yes, Data studio is faster with telemetry disabled but queries are still slower than with other application
e.g. with SQLPRO studio connection to DB is less than 1sec (5-15 second with ADS) and execute queries are faster too, getting 1000 rows is about 1.214 sec , and 5-20 seconds in ADS (can't be more precise, the time for the query is always 00:00:00 !!)