Users Guide
Minimum Login Roles for Microsoft SQL Server
The following table provides information about the minimum permissions for SQL Server based on dierent 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.
Database Size and Scalability
The following table provides information about the changes to the database size in an environment with 8000 devices.
Table 3. Database Size and Scalability
Events Database Size
Initial database size 113.38 MB
After discovery and inventory of 8000 devices 846.97 MB
After 20000 alerts are generated 851.85 MB
After deleting 20000 alerts 847.6 MB
During the daily maintenance, OpenManage Essentials compresses and optimizes 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.
NOTE: OpenManage Essentials can maintain up to 175,000 task execution history details without any issues. If the task
execution history details exceed 175,000, you may experience problems starting OpenManage Essentials. The earlier task
execution history records are purged when the limit set under Task Settings → Task Execution History Records to be
Retained is exceeded. The task execution history details of few tasks are not purged. For more information, see Task
Settings. It is recommended that you periodically delete task execution history details that you may no longer require or
change the purge settings of task execution history details.
NOTE: For more information, see the
OpenManage Essentials Scalability and Performance
technical white paper at
DellTechCenter.com/OME.
23