SQL: 001 : GLOBODOX loading slow...

SQL: 001 : GLOBODOX loading slow...

Symptoms
You may experience slowness while logging into GLOBODOX or while browsing through documents, etc. There may be many reasons for this but we have found that the below solution has worked in many cases.

Solution :

Step 1: Set auto close as off in the SQL Server based MainDB. 

Follow the steps below to do this...
  • Back up the GLOBODOX Databases after making sure Globodox is not being accessed from any of your network machines.
  • Now, on the machine where SQL Server is installed, launch the SQL Command Line. You can open the SQL Command Line Window by pressing 'Windows button + R' from your Key Board.
  • Once the RUN dialog appears, type in sqlcmd.exe and hit Enter. The SQL Command Line window will launch.
  • At the Cursor type...

     alter database MainDB set auto_close off

  • Press Enter. The Cursor will now move to 2nd Row, now type GO and again press Enter.
  • If the Cursor returns to the next line without hitting any error, then the SQL Server based MainDB file is updated for optimum performance.
  • The same process will have to be performed on the MainDB_cache file as well.
  • At the Cursor type...

     alter database MainDB_cache set auto_close off

  •  Press Enter. Now type GO and press Enter.
  • Once, the Cursor returns to the next line close the SQL Command Line Window.
  • Restart the Globodox Server Service for the changes to take effect by following the below mentioned steps.
  • Go to Control Panel >> Administrative Tools >> Services panel.
  • Now, under Services search for ITAZ Globodox Server service.
  • Right-Click on this service and restart the same.
Now start GLOBODOX you will find it is loading much faster.

Repeat the above steps for other DB's as well.

If you now face the slow loading only on the client installations of Globodox then go to Step 2 

Step 2
  •     Close GLOBODOX and open Internet Explorer browser on the client machine.
  •     In Internet Explorer, go to Tools and click on Internet Options tab.
  •     Once the Internet Options dialog opens, navigate to Advanced tab.
  •     Under Settings >> Security option uncheck...
                Check for publisher's certificate revocation*
                Check for server certificate revocation*
  •     Click on OK to save the changes. Close Internet Explorer.
  •     Perform the above steps on all the client installations of GLOBODOX .
  •     Now start GLOBODOX it will load fast.
    • Related Articles

    • Restore GLOBODOX DBs using SQL Server Management Studio

      To restore the DBs using SQL Server Management Studio follow the steps below: Open 'SQL Server 2014 (or any) Management Studio'. On the 'Connect to Server' window, change 'Authentication' to 'SQL Server Authentication'. Please enter your MS SQL ...
    • Upgrading to GLOBODOX v10

      This instructions are only for upgrading your existing installation of GLOBODOX. Please read this article and make sure you have all the files that are necessary for the upgrade.  Before you proceed make sure... Check your maintenance subscription ...
    • Backup GLOBODOX DBs using SQL Server Management Studio

      To backup the DBs using SQL Server Management Studio follow the steps below: Open 'SQL Server 2014 (or any) Management Studio'. On the 'Connect to Server' window, change 'Authentication' to 'SQL Server Authentication'. Please enter your MS SQL ...
    • Migrate Globodox v10 MSSQL DB

      Step 1: Backup DB on old machine Follow instructions from the link below to take a backup of the MSSQL DB... https://www.globodox.com/support/help/index.htm?backup_a_ms_sql_db_main.htm Note: Make sure you take a backup of all the DBs. Make sure you ...
    • SQL: 002 : SQL Server does not exist or access is denied

      Error Message: ErrorCode: 61443 Message: Failed to connect to database 'MainDB'. (ErrNo:-2147467259 Details:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.) Cause: The error indicates that GLOBODOX is unable to ...