vCenter Server Database Monitoring captures metrics that enable the administrator to assess the status and health of the database server. Enabling Database Monitoring helps the administrator prevent vCenter downtime because of a lack of resources for the database server.

Database Monitoring for vCenter Server enables administrators to monitor the database server CPU, memory, I/O, data storage, and other environment factors for stress conditions. Statistics are stored in the vCenter Server Profile Logs.

You can enable Database Monitoring for a user before or after you install vCenter Server. You can also perform this procedure while vCenter Server is running.

1

Log in to a SQL Server Management Studio session as the sysadmin (SA) or to a user account with sysadmin privileges.

2

Run the following SQL commands to grant additional permissions to vCenter Server database login:

use master
go
grant VIEW SERVER STATE to user
go

vCenter Database Monitoring is enabled.