(Optional) Configure a Microsoft SQL Server Database User to Enable Database
Monitoring
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.
Procedure
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.
Configure Oracle Databases
To use an Oracle database for your vCenter Server repository, configure your database to work with
vCenter Server.
Procedure
1
Configure an Oracle Database User
on page 43
To use an Oracle database when you install vCenter Server, you must configure the database user.
2
Use a Script to Create a Local or Remote Oracle Database
on page 44
When you use an Oracle database with vCenter Server, the database must have certain table spaces
and privileges. To simplify the process of creating the database, you can run a script. You also can
create the database manually.
3
(Optional) Use a Script to Create the Oracle Database Schema
on page 44
The vCenter Server installer creates the schema during installation. For experienced database
administrators who need more control over schema creation because of environmental constraints,
you can optionally use a script to create your database schema.
4
Configure an Oracle Connection for Local Access
on page 46
Configure a connection for local access if you install vCenter Server on the same system as the Oracle
database.
5
Configure an Oracle Database Connection for Remote Access
on page 46
Before a vCenter Server system can access the Oracle database remotely, you must configure an Oracle
connection.
6
Connect to an Oracle Database Locally
on page 47
Before a vCenter Server system can connect to an Oracle database locally, you must set up the
connection.
vSphere Installation and Setup
42
VMware, Inc.
Summary of Contents for VS4-ENT-PL-A - vSphere Enterprise Plus
Page 6: ...vSphere Installation and Setup 6 VMware Inc ...
Page 8: ...vSphere Installation and Setup 8 VMware Inc ...
Page 10: ...vSphere Installation and Setup 10 VMware Inc ...
Page 28: ...vSphere Installation and Setup 28 VMware Inc ...
Page 70: ...vSphere Installation and Setup 70 VMware Inc ...
Page 100: ...vSphere Installation and Setup 100 VMware Inc ...
Page 122: ...vSphere Installation and Setup 122 VMware Inc ...
Page 138: ...vSphere Installation and Setup 138 VMware Inc ...