Open file takes extremelyn long time when running on Remote Desktop and file is located local

[Roger Bertilsson]

Hi! I run PLSQL Devloper (version 10.0.5.1710) on a server which I use Microsoft Terminal Service Client (version 6.3.9600.16415) to connect to ther server. In MSTSC I have enabled local drives to be able to open local files on drives from the remote Desktop connection)

When opening any kind of file (*.sql, *.pdc, *.pck etc) located on my local drives (named C on MY_COMPUTERNAME), the opening of the file takes extremely long time, approx 2 minutes for a 5 KB file. If I try to open the same file with notepad or any other program it opens in 1 second.

If I copy the file from my local drive onto a folder on the server, the copying takes about 1 second and then opening of that file takes also 1 second.

There seem to be a problem when PLSQL Devloper running on a server and connecting using MSTSC tries to open files located on the clients local drive.

Can someone help me on what might cause PLSQL Developer to be so slow on open files on my local drives.

Thanks in advance /Roger

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[Roger Bertilsson]

How do I send debug files to you, I can't find how to attach them to this topic and I can't find a way to send them in a private message either.

/Roger

 

[Marco Kalter]

You can send it by e-mail to support@allroundautomations.com.

 

[Roger Bertilsson]

Debugfiles was sent 25 november 2014 16:26 (CET +1).

Have you recieved these files?

Can they tell you what makes plsql developer take so long time to open files located on clients local disks?

/Roger

 

[Marco Kalter]

I don't think we have received them. Can you resend and make sure that you refer to this forum topic in the e-mail?

 

[Roger Bertilsson]

Now I have resent debugfiles.

Debugfiles are compressed into a zip file, are there any problems with that?

/Roger

 

[James B]

You are most likely running into an underlying Windows issue that causes slow transfer speeds to and from mapped drives/UNC addresses. We encountered this on our network, and it's *painful*. The problem is excess traffic between your computer and the server.

More information here: http://blogs.technet.com/b/askperf/archive/2007/09/21/windows-explorer-and-smb-traffic.aspx

If you copy the text in the grey code box on that page to a text file and save it as "SMB Traffic Fixes.reg", you can right-click the file and pick "Merge". This will add the settings to the registry, and decrease the traffic between client and server significantly. (Let me know if you have trouble seeing it; I can copy and paste my file here)

I'm lazy, so an explanation and the results from the email I sent to our team:

If copying files, listing directories in explorer, etc. on remote servers is extremely slow for you, attached is a registry file of settings that fixed the issue for me. I was getting speeds of 2-3KBps, sometimes less, when reading text files or uploading zip files for deployment... after this fix, 5MB zip files copy and open instantly through UNC paths and mapped drives. A 285 MB file copied at ~8.5 MB/second and finished in less than 30 seconds. A restart should not be required for the settings to take effect, but you'll probably have to at least open a new explorer window, and YMMV.

The slow-down comes from excessive SMB traffic, which is generated by a number of different events; each of the below settings addresses a different one. Many of them happen in the background (such as verifying files in the recent files list that were opened through a mapped drive or UNC path). I investigated most of the settings to understand them, but at some point I decided I didn't really need to know what SCAPI was and called it legit. Suppression policies are in general related to context menus, etc., to tell Windows when it should display items and when it shouldn't. I'm not sure what x0010 0000 is suppressing, but whatever it is generates SMB traffic when displayed.

Possible downsides of doing this: If you're viewing a remote folder, and I upload a file to it, you won't see it until you hit refresh. Certain right-click menu items on a remote file might not be displayed? I can't find any that I care about that missing. That sort of thing. You could probably pick and choose from the settings, get a partial improvement by selecting only some of the settings... if I find I'm missing something I want to see, I'll dig to figure out how to display it.