Users Guide

Minimum login roles for Microsoft SQL Server
The following table provides information about the minimum permissions for SQL Server based on dierent installation and upgrade
use cases:
Table 2. Minimum login roles for Microsoft SQL Server
Number Use Case Minimum Login Roles for SQL Server
1 Installing OpenManage Essentials for the rst time and you
select the Typical option during the installation process.
sysadmin access on the installed instance.
2 Installing OpenManage Essentials for the rst time, you
select the Custom option during the installation process
and an empty OpenManage Essentials database is present
(locally or remotely).
NOTE: If you select the Custom install option and
do not enter any credentials then the installation is
considered as a Typical installation and sysadmin
rights are required.
db_owner access on the OpenManage Essentials
database.
3 You are installing OpenManage Essentials for the rst time,
you select the Custom option during the installation
process, and an empty OpenManage Essentials database is
not present.
dbcreator access on the server.
4 Upgrading OpenManage Essentials from an earlier version
to the latest version and an OpenManage Essentials
database is present (locally or remotely).
db_owner access on the OpenManage Essentials
database.
Recommended database size
The following table provides information about the recommended database size for common use cases. However, it is recommended
that you congure the database size based on the environment with dierent hardware congurations, and also regularly monitor the
growth of the database size.
Table 3. Recommended database size
Recommende
d database
size
Large deployments Large deployments Large deployments Medium deployments Small
deployments
Number of
devices
8000 5500 2000 500 100
SQL Server
database size
14 GB 10 GB 6 GB 2 GB 1 GB
During the daily maintenance, OpenManage Essentials compresses and optimizes the database. Also, for optimal performance of
OpenManage Essentials, monitor the database size and congure the Autogrowth/ Maxsize setting accordingly. It is recommended
that the size of the log database must be 1.5 times the maximum size of the database. OpenManage Essentials also downloads
updates for managed servers. These updates are saved in the local le system (not in the database) where OpenManage Essentials
is installed.
22