Nsryjdtyk

When submitting U-SQL scripts to ADLA Visual Studio freezes for a few seconds, and is constantly spiking for about 1-2 sec for all changes in the editor.

VS works fine with all other languages than U-SQL for me.

Similiar unsolved case: Msdn forum

Version: VS community 2017 15.6.7
Azure Data Lake Tools for Visual Studio - 2.3.4000.6

I'm not entirely sure what you are describing when you say "freezes" and "spiking", so my apologies in advance if this is not helpful. Two scenarios come to mind:

1) When you submit a U-SQL script to a Data Lake for execution, there is a period where Visual Studio is preparing the job. If you look in the Output Window you should see the activity. This can sometimes take a few minutes and appear as though nothing is happening, but it is actually quite busy.

2) There is a bug in VS tooling that causes code editing delays and "freezing" while editing U-SQL scripts. This specifically happens when the "ADLA Account" drop down references a remote account. If you change it to "(Local-machine)" while editing, the problem should go away (just don't forget to change it to the correct account before you submit the job).

If neither of those is relevant to your problem, please post some more details.

Hi I am a person who raised MSDN question. I hope this will help you trying to find work arounds.
Maybe my issue seems same with Refi, Visual Studio editor for U-SQL is "laggy". Once in 3-10 seconds I experience suspending response on the editor.

I have asked and tried to fix this issues with Microsoft support team, however I couldn't find final solution.

I describe my trials which almost failed.

Issues

Intermittent freezing during editing U-SQL. Right after opening files sometimes laggy. And continuously happens whole editing time.
To check how frequent this phenomena happens, you can check issues only moving cursor on source code.

Trials

1. 
   

   Editor choice
   There are 2 variants of dedicated editor of U-SQL.

   
   
   
   
   
   • Common Language Editor Supporting TextMate Bundles (Default)
   
   
   • Source code (text) editor
     The former have flowchart view and I guess it is the cause of issue and the latter one doesn't, however even after I switched to the latter one I still have same issues. Of course you can use other editor in VS or outside VS, only these 2 editors have ADLA launcher which is maybe a only reason to use ADLA plugin.
     Using 2 editors in other language (C#, R, Python) doesn't show such issues.
   
   
   
   


2. 
   

   Intellisense

   
   
   

   I some times see progress message below editor which tells editor "computing intellisense ..." during freeze time. Once I turned off all of intellisense options in tools-options panel, I still have same issues. Even if I turned off it, I still have "computing intellisense ..." message.

   
   


3. 
   

   Clearing cache
   It is a general countermeasure when VS is unstable. I tried some of them includes :

   
   
   
   
   

   • delete the component cache
     Delete the %USERPROFILE%AppDataLocalMicrosoftVisualStudio14.0ComponentModelCache directory
     https://www.matteopozzani.com/visual-studio-cache-cleanup/

   
   

   • clear MEF cache
     using "Clear MEF Component Cache" plugin.
     https://marketplace.visualstudio.com/items?itemName=MadsKristensen.ClearMEFComponentCache

   
   
   
   

I have also tried some uninstall-install of Data Science workload and updated several times to latest version, and none of them affected the issue.

4. Project files
   In the plain U-SQL project, I don't have this issue. So I cleaned up project files or solution files. However same issues continue. I checked project file or solution file, and I couldn't find possible issues in descriptions in them.
   My solution is composite (U-SQL, C#, R, Python) and large size so I separate my U-SQL project alone in a new solution, however the issue exists in a new solution too.

Currently latest suggestion from Microsoft support team is, the issue is caused by “Go To Definition”/”Find All Reference” feature which cannot currently be disabled. For large amount of scripts which have much references in the code with error cause continuous recalculating references. I am not sure why the issue is triggered only in U-SQL.

My only work around is using external editor to edit, and use launcher in VS.

list of QA

• MSDN social forums
  https://social.msdn.microsoft.com/Forums/vstudio/en-US/5787a2b5-0cc0-4b26-b906-9ca9b0617bcc/visual-studio-usql-editor-freeze-periodically?forum=visualstudiogeneral#fc02e157-de35-4114-8020-2d6e10fa7393https://social.msdn.microsoft.com/Forums/vstudio/en-US/5787a2b5-0cc0-4b26-b906-9ca9b0617bcc/visual-studio-usql-editor-freeze-periodically?forum=visualstudiogeneral#fc02e157-de35-4114-8020-2d6e10fa7393




• Azure Data Lake and Stream Analytics Tools plugin for VS
  https://marketplace.visualstudio.com/items?itemName=ADLTools.AzureDataLakeandStreamAnalyticsTools#qna




• Visual Studio developer community
  https://developercommunity.visualstudio.com/content/problem/320054/u-sql-editor-freeze-intermittentrly.html

For my case, updating VS2017 to 15.9.7 recently solved the issue above.
I am not sure what exactly change the issues.