web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Slow upgrade performance
Microsoft Dynamics GP (Archived)

Slow upgrade performance

(0) ShareShare
ReportReport
Posted on by Robyn 1,753

We have a small installation in size  9 companies less than 3 gigs of data all told.  We are moving from GP10 to GP 2013.  The GP10 SP went very quickly and smoothly.  We are not doing the GP2013 upgrade on the new server and it is taking just over 3 hours per database.  We started it at 10 pm last night and as of 8am this morning it has finished 3 databases plus Dynamics and is on the 4th now.  We have looked at the SQL optimizations and all looks well.  We are not tapping anything extremely hard on memory, cpu etc.  This is a virtual server.  OS and SQL are 2012.  We changed the database versions to 2012.  We have also looked at file growth options on the mdb and ldb for the GL30000 change but half of these companies have no data in the GL30000 table.  Typically I see the upgrade take about 45 minutes to an hour and half per company.  This seems very slow.  Any ideas?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I rarely see upgrades tax a server.  Our upgrade from 2010R2 to 2013 took 23 minutes per company and it was not stressing any part of the server, at least according to the performance monitor.  You mentioned you're running on a virtual server...my first thought was you're having issues with your shared storage.  

    It has been my experience that database size does not affect the time it takes to upgrade the database.  What are your server specs?

    Are you running on full recovery or simple recovery? If you're running full, it's recommended to grow your log file before the upgrade starts.

  • Robyn Profile Picture
    Robyn 1,753 on at

    We are running in simple recovery.  I don't have access to the machine at the moment but is on windows server 2012, SQL 2012.  Has 7 gigs of RAM, 100 gigs of harddrive space.  One processor but I cannot give specs.  Nothing that should be causing this type of slowness.  I have experienced this at another client on virtual but never figured out why.  Took about 7 hours per db on that machine.  I am at a loss other than to just let it run.  I know nothing about Virtual machines.  How does the shared storage work?  How cold this be an issue?

  • Community Member Profile Picture
    Community Member on at

    Here's my opinion: 7GB of ram is very little, but if you're saying all nine databases combined total three GB, that's not your issue.

    Yes, with any sort of VM you're going to have shared storage, be it a SAN, iSCSI, DAS, ect.  Whomever provisions your storage should try and get you your own spindles that are only used for SQL, not for five other things as well.

    Your slowness could be caused by any number of things, and without some other numbers/measurements, it's hard to say what is exactly causing it.  If you can get an idea of the underlying WMWare/HyperV environment, the number of CPU's assigned to your VM, the make/model of those CPU's, and the wait stats for the VM, we could try and figure out what's going on.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Does your GP installation include Analytical Accout8ing and/or Fixed Assets? I know the issue with Fixed Assets has been corrected in GP 2013 R2.

  • Robyn Profile Picture
    Robyn 1,753 on at

    Did not include AA,  FA is installed but not yet used.  No data in those tables.  All in all it took over 24 hours for it to run the upgrade.  Working on the server post upgrade has been fine.  No users have had any issues posting or running reports.  Very weird.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    GP 2013 R2 has just been released. Try to upgrade to that version. The issue with Fixed Assets has been corrected with that version.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans