Configuring Microsoft SQL Server Express

Create a database user

PaperCut MF requires a user to connect to the database. To create this user:

1. In SQL Server Management Studio Express tool, right-click the Security > Logins node; then select New Login.

2. Enter the username (e.g. papercut).

3. Change the Server Authentication to SQL Server and Windows Authentication mode.

4. Enter the user's password.

5. Disable password expiration.

6. Click OK.

7. After creating the PaperCut MF database, assign this user db_owner permissions on the database, so that it can create the required database tables.

8. To initialize the database, follow the instruction in Upsize to an external database (RDBMS).

Set statistics to auto update

1. In SQL Server Management Studio Express, right-click the database; then select Properties.

   The Database Properties dialog is displayed.

2. Scroll to the top of the Other options list.
3. In Auto Update Statistics, select True.

4. Click OK.

Note:

Alternatively, you can set up this optimization as a scheduled task after hours to ensure you see no performance issues due to database indexing problems.

The optimization we recommend you run is:

• exec sp_msForEachTable @COMMAND1= 'DBCC DBREINDEX ( "?")';

• exec sp_updatestats;

Databases with large databases with millions of print jobs can complete this command in less than three minutes. The result was seen where reporting took 10-15 minutes before optimization, and now takes a matter of seconds.