VMware VS4-ENT-PL-A Setup Guide - Page 42
Con a Microsoft SQL Server Database User to Enable Database Monitoring
View all VMware VS4-ENT-PL-A manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 42 highlights
vSphere Installation and Setup (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. 42 VMware, Inc.