Solved

Replace command slowness - VFP in Server 2008

Posted on 2011-03-23
8
868 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 41

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 41

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
 

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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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 41

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I have been working as System Administrators since 2003. I recently started working as a FreeLancer and was amazed to find out that very few people are taking full advantage of their Windows Server Machines. Microsoft Windows Server comes with so…
I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now