Problems with SQL making GoldMine unusable at times having to restart SQL Services and reign in memory usage.

Version 1

    Details

     - Users reporting they were unable to log into GoldMine until SQL Services were restarted on the Server. 

    - Happening several times over an extended number of days.

     


    Resolution

     

    [CAUSE]
    The SQL server database is set to AutoClose (On)

    [RESOLUTION]
    NOTE: The information below is provided AS IS with No Warranty.  Please contact a GoldMine Solutions Partner if not comfortable administrating the SQL Server.

    1. To fix the issue please turn the Database AutoClose to OFF instead of ON.
    Below are a couple of helpful threads to accomplish this task:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/12a81919-8b6e-42f7-be03-ca2e81608ed6/eventlog-grows-constantly-with-repeating-message-starting-up-database-adventureworks2012?forum=sqldatabaseengine