**\u00a0UPDATE **\u00a0– I’ve managed to come up with a work around,\u00a0i’ve detailed it at the end of\u00a0the post \u00a0<\/p>\n
I need some help<\/p>\n
I recently did an SBS 2003 installation for a client. They have been on SBS 2000 for a long time and getting them to move on was “painful”<\/p>\n
Anyway the migration went well and we were getting people back to work when someone noticed their custom LOB application wasn’t performing too well<\/p>\n
It’s a Visual Foxpro 6 application (yes i know it’s not supported anymore) and in certain parts of the system it take a long time to perform table operations (filter, select,etc) where it was instantaneous on the old server<\/p>\n
I’ve done a lot of troubleshooting to make sure it’s not corrupt indexes, problems with the infrastruture, etc<\/p>\n
I’ve double checked that all works well if i connect back to the old server and it is fine if i log onto the new server and run it locally so i think the problem is with Windows 2003 and Visual FoxPro not playing too nicely when serving the data over the network<\/p>\n
They are aware that Visual Foxpro 6 is a little long in the tooth and have plans to have get the program rewritten in a modern language but this isn’t going to happen overnight<\/p>\n
I’m also not too keen on telling them their brand new server cripples their main business application!<\/p>\n
I’m toying with setting up a virtual server but this may get expensive as a temporary fix!<\/p>\n
Any suggestions would be\u00a0appreciated!<\/p>\n
Thanks\u00a0<\/p>\n
** UPDATE **<\/p>\n
Looks like my\u00a0theory about\u00a0the problem lying with how Windows 2003 gets the data onto the network was correct<\/p>\n
As part of the new server installation the client also purchased a NAS. This is to be used for storing backup images.<\/p>\n
I’ve put the data onto the NAS and the problem goes away. The NAS is linux based i believe<\/p>\n
This isn’t a fix but more of a workaround. The client is aware that they need to get the software updated but this will work until that gets sorted. I’d still like to hear anyones thoughts as why i was having the problem in the first place.<\/p>\n","protected":false},"excerpt":{"rendered":"
**\u00a0UPDATE **\u00a0– I’ve managed to come up with a work around,\u00a0i’ve detailed it at the end of\u00a0the post \u00a0 I need some help I recently did an SBS 2003 installation for a client. They have been on SBS 2000 for a long time and getting them to move on was “painful” Anyway the migration went<\/p>\n