Solved

Replace command slowness - VFP in Server 2008

Posted on 2011-03-23
8
917 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…
Suggested Courses

628 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