VMware VS4-ENT-PL-A - vSphere Enterprise Plus, Setup Manual

Page: 39 / 276

5 (Optional) You can also run the following scripts to enable database health monitoring.
job_dbm_performance_data_mssql.sql
process_performance_data_mssql.sql
6 For all supported editions of Microsoft SQL Server (except Microsoft SQL Server 2005 Express and
Microsoft SQL Server 2008 R2 Express), run these scripts to set up scheduled jobs on the database.
These scripts ensure that the SQL Server Agent service is running.
job_schedule1_mssql.sql
job_schedule2_mssql.sql
job_schedule3_mssql.sql
job_cleanup_events_mssql.sql
job_topn_past_day_mssql.sql
job_topn_past_week_mssql.sql
job_topn_past_month_mssql.sql
job_topn_past_year_mssql.sql
job_property_bulletin_mssql.sql
7 For all the procedures you created in Step 4 , grant the execute privilege to the vCenter Server database.
grant execute on purge_stat2_proc to vCenter_db_user
grant execute on purge_stat3_proc to vCenter_db_user
grant execute on purge_usage_stat_proc to vCenter_db_user
grant execute on stats_rollup1_proc to vCenter_db_user
grant execute on stats_rollup2_proc to vCenter_db_user
grant execute on stats_rollup3_proc to vCenter_db_user
grant execute on cleanup_events_tasks_proc to vCenter_db_user
grant execute on delete_stats_proc to vCenter_db_user
grant execute on upsert_last_event_proc to vCenter_db_user
grant execute on load_usage_stats_proc to vCenter_db_user
grant execute on load_stats_proc to vCenter_db_user
grant execute on calc_topn1_proc to vCenter_db_user
grant execute on calc_topn2_proc to vCenter_db_user
grant execute on calc_topn3_proc to vCenter_db_user
grant execute on calc_topn4_proc to vCenter_db_user
grant execute on clear_topn1_proc to vCenter_db_user
grant execute on clear_topn2_proc to vCenter_db_user
grant execute on clear_topn3_proc to vCenter_db_user
grant execute on clear_topn4_proc to vCenter_db_user
grant execute on rule_topn1_proc to vCenter_db_user
grant execute on rule_topn2_proc to vCenter_db_user
grant execute on rule_topn3_proc to vCenter_db_user
grant execute on rule_topn4_proc to vCenter_db_user
grant execute on process_license_snapshot_proc to vCenter_db_user
grant execute on l_stats_rollup3_proc to vCenter_db_user
grant execute on l_purge_stat2_proc to vCenter_db_user
grant execute on l_purge_stat3_proc to vCenter_db_user
grant execute on l_stats_rollup1_proc to vCenter_db_user
grant execute on l_stats_rollup2_proc to vCenter_db_user
grant execute on process_temptable0_proc to vCenter_db_user
grant execute on process_temptable1_proc to vCenter_db_user
grant execute on process_temptable2_proc to vCenter_db_user
If you ran the script
process_performance_data_mssql.sql
in Step 4 , grant the following execute
privilege to the vCenter Server database.
grant execute on process_performance_data_proc to vCenter_db_user
Chapter 3 Before You Install vCenter Server
VMware, Inc. 39