PERFORMANCE SETTINGS
The following properties can also be set in the DatabaseSettings.config.xml file:
DatabaseConnectionFactory.MinimumPoolSize—Sets the minimum number of connections to the
database that are kept open. The default is 0.
DatabaseConnectionFactory.MaximumPoolSize—Sets the maximum number of connections to the
database that can be opened. The default is 100.
DatabaseConnectionFactory.CommandTimeoutInSeconds—Sets how long to wait for results to
start being returned in a query. The default is 120.
These settings can be used to improve performance when reading from and writing to the database.
CONFIGURE THE HP WEB JETADMIN BACKUP FOR A
REMOTE DATABASE
Administrators might want to run scheduled backups of an HP Web Jetadmin installation that points to
a remote SQL database. HP Web Jetadmin provides scripts to back up the default SQL Server Express
database instance that is installed with the base product. The script also backs up the HP Web
Jetadmin configuration settings.
If the backup and restore scripts from the HP Web Jetadmin installation directory (WJABackupRestore
directory) were used previously to back up the local HP Web Jetadmin installation, you might need to
consider the following options to make sure that the remote SQL database is backed up:
Option 1—Do not use HP Web Jetadmin to back up and restore the remote SQL database. There
might already be other processes in place for backing up the remote SQL database and the
HP Web Jetadmin settings directory. In this case, the HP Web Jetadmin script is not required.
Option 2—Continue to use the HP Web Jetadmin backup script, but remove or comment out the
lines in the script that back up the remote SQL database. This allows the script to continue
backing up the HP Web Jetadmin settings directory. There might already be other processes in
place for backing up the remote SQL database. In this case, you do not need to use HP Web
Jetadmin to back up the remote SQL database.
Option 3—Modify the HP Web Jetadmin script to back up the remote SQL database as well as
the HP Web Jetadmin settings directory. The lines in the scripts that back up the default SQL
Server Express database instance can be replaced with custom commands that back up the
remote SQL database. For example, the HP Web Jetadmin backup.bat file runs the following SQL
script on the same machine to back up the database:
%OSQL% -S localhost\HPWJA -E -i osql_backup.sql > osql_backup.log
To run the script on the remote SQL server, change this line to the following:
%OSQL% -H wksta_server -S SQL_server\Instance -U user -P password -
i osql_backup.sql > osql_backup.log
The following SQL script backs up a database named HPWJA to the specified DRIVE:\:
BACKUP DATABASE HPWJA TO DISK =
'DRIVE:\HPWJA_DB_BACKUP\HPWJA_DB_BACKUP.dat'
To back up any database name to a shared UNC path, change this line to the following:
BACKUP DATABASE database_name TO DISK = '\\WJA
_server\shared_directory\HPWJA_DB_BACKUP\HPWJA_DB_BACKUP.dat'
The backup.bat file creates a temporary directory to write the .dat file, and then removes the
temporary directory after the .dat file is copied to the Program Files location. Because the backup.bat
(43 strony)
(83 strony)
(125 strony)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji