00900057-02_IM_Performance_Monitor_2.1_EN.pdf - 第38页
ASM Performance Monitor 2.1 / Installation Manual 01/2021 Edition 38 4.14.1 Creating ASM Performance Monitor Database This dialog is only displayed if the Show dialogs to change the d atabase settings option was selected…
ASM Performance Monitor 2.1 / Installation Manual 01/2021 Edition
37
4.14 Changing Default Database Settings (Option)
The default database settings can be changed in the Connect to SQL Server dialog, see section
4.6.
Figure 4-29: Changing default database settings
► Select the SQL Server instance that you are installing to.
► Select Show dialogs to change the default database settings if you want to change the
proposed default values for creating the database.
► Click the Next button.
The following checks are performed:
– Check for correctness of the entered login parameters and establishment of a connection.
– If the database already exists on the selected SQL server, check for the current version or a
possible update to the current version.
If the checks fail, an appropriate error message is displayed.
If the checks are passed, the next dialog is displayed. The next dialog depends on whether the
database already exists or not.
ASM Performance Monitor 2.1 / Installation Manual 01/2021 Edition
38
4.14.1 Creating ASM Performance Monitor Database
This dialog is only displayed if the Show dialogs to change the database settings option was
selected and if the APMFacotryDB database does not exist yet.
Figure 4-30: Create database dialog
► Define the database files. For each database file, you can set the following parameters:
Storage location of the database file
– Set the default value of the installation.
– Set the default value of the SQL server. (Recommended)
– Browse for the folder. (Only available on local SQL server instances)
WARNING
Installing on a remote SQL server instance
When installing on a remote SQL server instance the paths provided here are relative to
the file system target computer. Make sure the folders exist – otherwise the installation
may fail.
Initial file size
The initial file size when the database is created.
Auto Growth
The file size can increase if the initial file size is used up.
Growth size
The size by which the database file is automatically increased, if necessary.
ASM Performance Monitor 2.1 / Installation Manual 01/2021 Edition
39
Maximum size
The size up to which the database file is allowed to grow.
► Click the Next button.
The Backup directory dialog is displayed, see section 4.15.
4.14.2 Setting Up Database Users
If several database users are defined in an installation, the Assign a login to the database user
dialog is displayed for each SQL login. In ASM Performance Monitor, two database users are
available:
1) Name: APMDBA
Type: Database User
Databases: FactoryDB and line databases
Required For:
– APMDBA is an SQL server account and has sysadmin rights at DB Server level and is the
administrator (db_owner) of the "APMFactoryDB" database and has all the permissions to
change anything in the database.
– This user also has the same rights on all the line databases.
– All the queries on connections to FactoryDB and line databases also use this account.
– If this user already exists, then it gets updated. Otherwise, it will be created by the installer.
2) Name: APM_SSIS
Type: Windows Account
Databases: FactoryDB and SSISDB
Required For:
– This user is a Windows account and is required to execute the SSIS package. The access
rights this user require are db_datawriter and db_datareader for FactoryDB and
db_datawriter, db_datareader, ssis_logreader, ssis_admin, ssis_failover_monitoring_agent
for SSISDB for some operation. Currently, the APM_SSIS database user has the same
access rights as the APMDBA database user, so the before mentioned individual rights are
not specifically granted.