Summary

If the document window is configured to display thumbnails, opening a document may take a long time when using Microsoft SQL Server 2005 Express Edition.

Cause

By default, SQL Server 2005 Express Edition enables the AUTO_CLOSE option for new databases. This option automatically shuts down databases without active connections. This option can negatively impact performance as SQL Server 2005 Express Edition will continuously start and shut down your Laserfiche repository's expansion databases as users open and close documents.

Resolution 1

There is a hotfix available for Laserfiche 7.2.x. The fix disables the AUTO_CLOSE option when creating new expansion databases.

To update Laserfiche 7.2.x

1. Click the following link to download a zip file containing the hotfix files.
   Hotfix_SCR30054.zip
2. Extract scr30054.sql to a temporary location.
3. Run the scr30054.sql script on your database.
   1. Click Start and then click Run.
   2. In the Run dialog box, type the following and then click OK to run the script.

      sqlcmd -E -S SQLExpressInstance -d "DatabaseName" -i "PathToscr30054.sql"

      SQLInstance is the name of your SQL Server Express instance name.

      DatabaseName is the name of the main SQL database associated with your Laserfiche repository.

      PathToscr30054.sql is the full path (including the file name and extension) to the extracted scr30054.sql file.

4. Replace your existing msde.sql file with the updated version included in the zip file. By default, msde.sql is located at "C:\Program Files\Laserfiche\Client\Admin\SQL\ms."

You must manually disable the AUTO_CLOSE option for your existing expansion databases. Please see Resolution 2 for the appropriate procedure.

Resolution 2

Disable the AUTO_CLOSE option on all the expansion databases.

To disable the AUTO_CLOSE option using SQL Server Management Studio

1. Load Microsoft SQL Server Management Studio and connect to the instance associated with your Laserfiche repository.
2. Expand the Databases item.
3. Right-click the first expansion database, DatabaseName_Data_1, and click Properties.
4. In the properties dialog box, select the Options item from the list on the left.
5. On the right, select the Auto Close option and set it to False.
6. Click OK to save your changes.
7. Repeat steps 3-6 for each additional expansion database.