December 1, 2006 at 7:29 am
Good morning. We are running SQL 2000 SP4 on Windows 2K3 SP1. We are in the process of upgrading Great Plains from version 8 to version 9 and the initial database re-structuring process is taking quite a long time. There are 31 company databases, totally a size of 20 GB. Is there something that I can do to observe what's going on with this process and why it is taking so long. Anyone have any ideas as to why it might be taking so long. I am currently running Profiler, but any other suggestions? Thank you.
Chris
December 1, 2006 at 7:48 am
How long did you expect it to take?
How long did it take when you did a test upgrade on a test server?
And I don't have any other suggestions besides profiler... but even that won't tell what is left to do so it might be somewhat in vain. All it'll tell you is that something is happening on the server, but that doesn't mean that nothing is happenning at all.
December 1, 2006 at 8:49 am
Thanks for the reply, Ninja's_RGR'us.
Well, our consultant, who did previous upgrades for us and other companies, suggested that it should have been done or nearly done by this morning (we left it running overnight). As he explained it to me, all the process does is BCP data out of the GP tables and modify the table structure, according to the new version specs and then BCP the data back in. He said that it should be doing this on the SQL server, not the GP server. Can anyone verify this? I was thinking that perhaps it is doing the BCP on the SQL server, but writing the temp files back to the GP server and there is latency in that process that is causing the entire process to appear slow. What do you think?
Something interesting...we turned off Symantec on the GP server and the processing did speed up.
We actually didn't do a test upgrade. I know...bad practice. However, we did do DB backups before doing the upgrade, so that we could roll-back easily, which we are doing right now.
Thanks...Chris
December 1, 2006 at 9:30 am
Alright, let us know how this turns out. Can't offer more support at this point !?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply