Improve company productivity with a Business Account.Sign Up

x
?
Solved

Replace command slowness - VFP in Server 2008

Posted on 2011-03-23
8
Medium Priority
?
933 Views
Last Modified: 2012-08-13
My company has an extensive, mission critical VFP 9 application in use in numerous sites.  One client has recently upgraded to Server 2008 R2, and running it numerous VM's (were running XP, now running Server 2008) and numerous TS sessions.  We are not explicitly limiting RAM usage (Sys(3050)) yet, but think the VMs may have a limit.  We use a standard VFP database, with extensive use of BEGIN and END transactions for data changes, no buffering.  
There appears dramatic slowing of the application at random locations, typically around record replaces.  ContrAcct had the same question a while back but a non-specific solution was forced.  We use minmal specific record locking but acknowledge this may be a factor in this environment.  
Virus control is turned off, machines are all local at the site.
Has anyone had real problems around this and identified real specific solutions?
Thanks
0
Comment
Question by:kiwivfp
  • 4
  • 3
8 Comments
 
LVL 44

Assisted Solution

by:pcelba
pcelba earned 1600 total points
ID: 35197405
You should also turn off SMB2 and oplocks. Both on server and client side. Administrators should know how to do it.
0
 

Author Comment

by:kiwivfp
ID: 35202201
Thanks pcelba.
SMB / SMB2 was discussed this am - expect to do this today.

Oplocks was turned off from the TS client side - need to check data server and the newly created S2008 VM clients.  I think there may be issues (other external services etc) that need it on - may need to move the data to another server.

Have you actually seen this explicitly fix situations in the past?

Will let you know how we got on today

Regards
0
 
LVL 44

Assisted Solution

by:pcelba
pcelba earned 1600 total points
ID: 35202951
Yes, turning oplocks and SMB2 off was always helpful for shared file access like FoxPro or Access.
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 

Author Comment

by:kiwivfp
ID: 35210500
So we tried all these things and still had issues.  Finally got the clilent to move the data to a new Virtual 2003 dedicated server, and all seems OK.  Can't help thinking the 64 bit / Server 2008 issue may end up being a sideline and that there was an underlying issue with the original 2008 server, perhaps with a few network issues thrown in for good measure.  I will update in a few days.
Thanks all for input so far.
0
 
LVL 2

Assisted Solution

by:yoshua
yoshua earned 400 total points
ID: 35220532
take a look at the "tcp chimney offload". Disabling this "feature" sometimes help.
0
 

Accepted Solution

by:
kiwivfp earned 0 total points
ID: 35243690
Thanks pcelba and yoshua for the tips.  We were still getting sundry errors in the system from Server 2003, but different - "Unable to read file ..." indicated network drop offs.  Got soem repatching of the switch and this seems to be better - almost error free after 24 hrs.  As above, can't help thinking it may have been much the same issues but handled differently by Server 2008 and reported differently by VFP.  We also found another switch for a Term Serv registry re using the same directory structure.  
There are some other sites with similar issues but again, may be new hardware and network rather than just Server 2008.
I think we'll box on with these tips - thanks
 
0
 
LVL 44

Expert Comment

by:pcelba
ID: 35243891
It is good to read you are getting stable environment.
0
 

Author Closing Comment

by:kiwivfp
ID: 35308456
I think the symptoms were clouded by network issues but all tips very helpful with server 2008.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A safe way to clean winsxs folder from your windows server 2008 R2 editions
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

608 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