Solved

Replace command slowness - VFP in Server 2008

Posted on 2011-03-23
8
903 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 42

Assisted Solution

by:pcelba
pcelba earned 400 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 42

Assisted Solution

by:pcelba
pcelba earned 400 total points
ID: 35202951
Yes, turning oplocks and SMB2 off was always helpful for shared file access like FoxPro or Access.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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 100 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 42

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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ADFS for O365 login page 2 75
Remove Extension 3 50
I need a simple SMTP solution for a printer/scanner 1 31
Domain trust created by PDC name 6 31
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.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

792 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