[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Slow access on Domain

Posted on 2011-10-23
16
Medium Priority
?
438 Views
Last Modified: 2012-08-14
I have a problem with slow access on a remote server. I am also permitted no access and given no information by the defence department to solve the problem. First of all the system is slow anyway because of bandwidth. Previously, my VO application which uses foxpro (.dbf) files worked fine with several users under workgroups on a local file server. Now they've created a domain and put the data on a remote server with the  .exe and .dll files on the local C: drive (which is hidden).
For the first user to access the files and produce a report, the speed is reasonably fast, but if they stay with the databases open and a second user runs the same report, the second user runs very slowly - up to 10 minutes instead of 3-4 seconds. This didn't happen under workgroups local server.
Does anyone have an idea why this happens please.
0
Comment
Question by:dengolding
  • 5
  • 4
  • 2
  • +2
13 Comments
 
LVL 43

Expert Comment

by:pcelba
ID: 37014757
0
 
LVL 30

Expert Comment

by:Olaf Doschke
ID: 37016849
Are you really talking about a remote domain here? Is it only connected via vpn connection, or is it still a local areea network? What is the bandwidth and ping time? To turn off oplocks is a candidate for a solution, but also the nature of dbf access needs more roundtrips from requesting a dbf to be opened and data to "stream" to the clients, than a real server database. That's making such VPN solutions a slow thing compared to LAN access, even with similar bandwidths.

Ping time, which about is the time for some minimalisitc request ("ping") to get to the destination and back is about: <1 ms for LAN, ~50ms for a server in the same country, at least as a rough value. It strongly depends. But it's this latency time which plays a bigger role, than just the bandwidth.

Bye, Olaf.
0
 

Author Comment

by:dengolding
ID: 37016895
Olaf, the server is on a 'server farm' somewhere in the middle of the UK and accessed by all points coast to coast. I have no access to it as it's a secure locked down system managed by an external agency for the government.
Everything I do is by guesswork so I'll send them the note about oplocks and see if anyone responds. My software is nation wide but they are very slow to do anything. Meanwhile my clients are going crazy.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 30

Expert Comment

by:Olaf Doschke
ID: 37020341
Well, rereading your outset, I get confused more and more: "data on a remote server with the  .exe and .dll files on the local C: drive (which is hidden).

What do you really mean by that? data is remote, exe and runtime is local? How does a hidden C: drive match to this specification? Or is both data AND exe+runtimes on a remote server or remote lan? Do users use your software via remote pc, terminal services? Do they have an installation of your exe on their pc and only data is remote? What is really where?

Bye, Olaf.
0
 

Author Comment

by:dengolding
ID: 37021595
The company that is used by this government organisation has packaged up all the software so that each user will download all software they have permission for to any terminal (pc) they log in to. It is loaded to the C: drive which is hidden to the user in 'my computer', but of course a shortcut can be made to boot the software. Presumably they did this to stop users playing with files on the C: drive.
The company has located the data files which my programme uses, on a server in the middle of the country together with data for all the other apps. They have not revealed the method of communication but I assume they use an intranet.
I hope this makes things clearer, but it is difficult when they are paranoid about security and and give us little or no information.
0
 
LVL 59

Expert Comment

by:LeeTutor
ID: 37164768
I've requested that this question be deleted for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
LVL 43

Expert Comment

by:pcelba
ID: 37164306
It is hard to help if the proven solution (switching SMB2 and oplocks off) cannot be implemented...
0
 

Author Comment

by:dengolding
ID: 37164765
Hello,

Sorry I disappeared for a while. A failing hard drive on my laptop has set me back and taken days to recover.  I have submitted the suggestions shown here to Atos who is the company employed by the government to run their computer systems. I can't tell you which dept but there's no secret. As yet they have not responded to any of my emails but I understand they have escalated the problem up a few levels, whatever that means. So, I'm working totally in the dark with no access to their system and no communication from them but the users are reporting this slowness all the time.
I'm sure they can impliment your suggestion pcelba but they keep quiet so I don't know if they have or have not or just haven't a clue.
I don't know how to progress this question now but will email all concerned again to see if they are taking any notice and report back. If however you feel the question should be closed then please tell me how I can report the solution when it's finally resolved.
0
 

Author Comment

by:dengolding
ID: 37164769
Please see my last posting and decide from there.
0
 

Expert Comment

by:JustAMod
ID: 37178101
I've requested that this question be deleted for the following reason:

Unfortunately, as the comments were not implemented, theres no way to know whether the information was good enough to solve the problem in THIS case. We only want VERIFIED solutions in the PAQ database. <br /><br />Restarting the Auto Delete process to finalize. <br /><br />Thanks, <br /><br />JustAMod <br />CS Moderator
0
 

Accepted Solution

by:
dengolding earned 0 total points
ID: 37175895
At last - they have found the cause which is stated as "legacy [XXX server name] NetApp filers". Perhaps that means something to those of you with domain experience/training. They moved some test  data files to other servers and found the problem went away.

How do I give points please. No-one had the soilution but they all offered help, so I can't mislead anyone searching that the solution was given here. Atos may be trying pcelba's solution but haven't  admitted it.
0
 
LVL 43

Expert Comment

by:pcelba
ID: 37178102
We don't need points but the solution should remain in the database.

Please mark the ID:37175895 as the answer.
0
 
LVL 43

Expert Comment

by:pcelba
ID: 37178115
If you don't like this solution in Windows OS zones then you may remove Windows zones and leave the question in FoxPro zone only.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn about cloud computing and its benefits for small business owners.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question