Open Forum

Expand all | Collapse all

Long wait for GP to open up

  • 1.  Long wait for GP to open up

    SILVER CONTRIBUTOR
    Posted 12-13-2018 09:46 AM
    Our GP is running on three remote servers.  From the time I click to open until the time I can actually type my username into GP takes 35 seconds.  Any ideas of where I should start poking around to speed this up?

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------


  • 2.  RE: Long wait for GP to open up

    GOLD CONTRIBUTOR
    Posted 12-13-2018 03:42 PM
    Check your Dex.ini file on each server. If SQL logging or debugger have been left on (=TRUE), that can negatively effect performance.
    The SQL Logging statements look like below:
    SQLLogSQLStmt=FALSE
    SQLLogODBCMessages=FALSE
    SQLLogAllODBCMessages=FALSE

    If SQL logging isn't on, you might want to set these 3 =TRUE and then log in to create a DEXSQL log you can use to assist troubleshooting.
    Just be sure to set them back to FALSE when you are done.


    ------------------------------
    Mark LeRette
    Application System Analyst II
    Muscatine Power and Water
    Muscatine IA
    ------------------------------



  • 3.  RE: Long wait for GP to open up

    TOP CONTRIBUTOR
    Posted 12-13-2018 03:59 PM
    Edited by Jo deRuiter 12-13-2018 03:59 PM
    Hi @Andy Berntson

    This could be any manner of things from just a slow-performing server to abandoned hard-coded URL's or File Locations in GP code.  If you guys once or still use Mekorma, for instance, and were on it from a few years back - their new code does not require the file location, but the old code did and that file location is not removed from the Mekorma tables - which means it pings that location until it times out trying.

    This is just one thing, but it could be quite a number of reasons that your GP has a delayed opening time.

    Check with your partner if you need help troubleshooting this.

    ------------------------------
    Kindest Regards,
    Jo deRuiter , MCP, DCP
    "That GP Red Head"
    AISLING DYNAMICS CONSULTING, LLC
    WEBSITE: https://aislingdynamics.com/
    BLOG: https://community.dynamics.com/gp/b/gplife
    GPUG Academy Instructor
    Dynamics GP Credentialing Council-Vice Chair
    770-906-4504 (Cell)

    ------------------------------



  • 4.  RE: Long wait for GP to open up

    GOLD CONTRIBUTOR
    Posted 12-14-2018 07:09 AM
    From your description of the problem, I understand you access the client from a remote desktop (terminal server).  You need to look at the remote desktop server performance.  SQL doesn't enter the mix until you attempt to log in.  Processor, available RAM, and disk speed will affect client performance.  Also, check possibly over-aggressive on-access Antivirus scanning.
    It's also possible that you're using roaming profiles which could be located on a different server, so network performance could come into play.

    ------------------------------
    Charles Ray
    Senior Systems Specialist
    CAL Business Solutions, Inc.
    Harwinton CT
    ------------------------------



  • 5.  RE: Long wait for GP to open up

    SILVER CONTRIBUTOR
    Posted 01-15-2019 04:17 PM
    Not sure if this well help anyone point me in the right direction, but we have three remote desktops where the client can be accessed.  Two of the remote desktops take about 35 seconds to where a person can enter their username, whereas the third remote desktop takes about 15 seconds.

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------



  • 6.  RE: Long wait for GP to open up

    TOP CONTRIBUTOR
    Posted 01-16-2019 08:16 AM
    Hi @Andy Berntson

    Please reply to this with a copy of the dex.ini from each remote server and a copy of the DYNAMICS.SET file from each computer.

    Also, please send each remote computers IT specs - Server Version, RAM, Memory, Avail Memory, etc.

    These would help us point you to the issue a lot faster than speculation.​

    ------------------------------
    Kindest Regards,
    Jo deRuiter , MCP, DCP
    "That GP Red Head"
    AISLING DYNAMICS CONSULTING, LLC
    WEBSITE: https://aislingdynamics.com/
    BLOG: https://community.dynamics.com/gp/b/gplife
    GPUG Academy Instructor
    Dynamics GP Credentialing Council-Vice Chair
    770-906-4504 (Cell)

    ------------------------------



  • 7.  RE: Long wait for GP to open up

    SILVER CONTRIBUTOR
    Posted 12 days ago
    Here are the dex and set files for our three instances.  I also included the sever specs for each.  For the memory specs are you wanting the space from the local (C) drive as well as the drive that our database is stored on?

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Attachment(s)

    txt
    Dex_A.txt   3K 1 version
    txt
    Dex_B.txt   3K 1 version
    txt
    Dex_SQL.txt   3K 1 version
    txt
    DYNAMICS_A.txt   9K 1 version
    txt
    DYNAMICS_B.txt   9K 1 version
    txt
    DYNAMICS_SQL.txt   9K 1 version


  • 8.  RE: Long wait for GP to open up

    Posted 9 days ago
    Hi @Andy Berntson

    We've actually been struggling with a similar issue that I think researching a response just helped me fix.

    In our case one interesting quirk we've found is that if you open GP a second time, it's actually much faster than the first.  i.e. - I can log on to one of our terminal servers and start GP.  It's about 25 seconds until the login is available.  If i close GP without logging in, the second time I launch it will only be 5-6 seconds.  That is similar both for a local install on my PC, and a test environment virtual terminal server that does not have roaming profiles.   On our production virtual terminal server that does have roaming profiles, it's consistently 25 seconds or so, even if we log in as a local user that doesn't have a roaming profile.

    So in researching this, I tried the SGDD principle (Same Google, Different Day) and came across an article that I had not seen before that I just tried, and seems to be the fix for our issue. After making the changes, logging out and back in again, GP now consistently gets to the login screen in 7 seconds. Since you're on Windows 2012, this may likely be your issue as well: https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/07/26/tuning-remote-desktop-services-2012-for-microsoft-dynamics-gp

    If that doesn't work:

    Looking at the files that you uploaded, I'd offer a couple of suggestions for you to look into:

    1. 12GB for a terminal server seems a little on the small size - Depending on your number of users, you may want to consider at least doubling that.
    2. Your SQL server also seems a little under equipped in the memory department as well- my answer to how much memory you want in a SQL server is usually "as much as you can afford". This likely is not affecting the initial startup, but will make users happier once they've logged in.
    3. You didn't specify if these are physical or virtual servers - if they are physical, you may want to consider adding some SSD drives which can be significantly faster than spindle drives.
    4. Your custom forms and report dictionaries appear to be located on a shared drive - If you have a lot of customization here, you may want to consider or experiment with moving them to the local server.
    5. Try disabling any real time virus scanning software or excluding the GP folder from live scans.
    Some not so obvious server oriented things to try:
    1. Update all BIOS and firmware to the latest recommended by your manufacturer
    2. Check the power settings both in the OS and BIOS to make sure they are not running in any kind of a 'balanced' mode
    3. Disable services not needed on a server i.e. bio-metric id services, location aware services etc. 
    Here is some very detailed troubleshooting instructions that will likely give you some best practices implementations along the way:
    https://mbs.microsoft.com/customersource/documentation/whitepapers/mdgp2010_whitepaper_performance.htm?printpage=false



    ------------------------------
    Jeff Woodard
    Chief Technical Officer
    Transportation Financial Services, Inc.
    West Palm Beach FL
    ------------------------------



  • 9.  RE: Long wait for GP to open up

    Posted 6 days ago
    Andy,

    The first thing I would do is turn off everything on the homepage.  These can get hung authenticating.  Then, I'd follow the great advice provided.

    Chris

    ------------------------------
    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries
    ------------------------------



  • 10.  RE: Long wait for GP to open up

    TOP CONTRIBUTOR
    Posted 5 days ago
    ​I would second @Andy Berntson and check to see what you have loading on your home page.  There are some "nice" reports and things that ping the database which can take a long time to render.  When I was testing for our upgrade to 2018, a user had some historical aging reports turned on and it was taking nearly an HOUR to log into to GP the first time.  OUCH!​​

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------



  • 11.  RE: Long wait for GP to open up

    SILVER CONTRIBUTOR
    Posted 5 days ago
    Is there a way for me to test a change in the Dex file while other users are still in the system?  I know to test a different Set file I could copy the shortcut of GP and have it point to a different Set file.

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------



  • 12.  RE: Long wait for GP to open up

    GOLD CONTRIBUTOR
    Posted 5 days ago
    @Andy Berntson , you can do that - a useable Dynamics GP shortcut is always in the form 'dynamics.exe xyz.set.  You can create a shortcut using your alternate set file, or just drag the set file over dynamics.exe in Windows Explorer.

    ------------------------------
    Charles Ray
    Senior Systems Specialist
    CAL Business Solutions, Inc.
    Harwinton CT
    ------------------------------



  • 13.  RE: Long wait for GP to open up

    GPUG ALL STAR
    Posted 4 days ago
    Hi @Andy Berntson

    The Dex.ini (global level) is read on demand and so you can make changes anytime. Some changes will not take effect until GP is launched again as that is when the setting is read, but other settings can be changed live and take effect immediately.

    If you want a separate Dex.ini file, you can add the path to the file as an additional parameter to the shortcut.  So you can have both a custom Dynamics.set (launch file) and a custom Dex.ini (settings file).

    Please note that user level Dex.ini settings are copied from the SY01405 table to a TNTXXXX.ini file in the temp folder while the user is logged in.  When the user logs out the contents are written back the SQL table.  You can make changes to the SQL table, but only when the user is not logged in, otherwise they are lost when the user logs out and the table is updated from the temporary .ini file.

    PS: Have a look at GP Power Tools - Dex.ini Configuration. This tool can update both global and user dex.ini settings without needing to visit the workstation and make changes manually.

    Regards

    David​

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------