VM1682

vCenter Database Architecture: Technical Deep Dive

This session is designed to give in-depth information on the architecture of the vCenter database. This includes database communication, table structure and troubleshooting common problems with the vCenter database. This presentation was originally developed to teach Technical Support Engineers to understand the database structure and also to help them understand the proper methodologies on how to troubleshoot the database when encountering problems. Architecture topics include, General overview and architecture of MSSQL; vCenter ODBC Connectivity; and the structure of the vCenter database (including vCenter Configuration information table structure, Host and VM database table structure, Authentication and Roles table structure, Performance Data table structure, and Task and Events table structure. Troubleshooting Topics include, excessive database growth (common problems that cause the growth and how to resolve the problems); SQL rollup job deadlocks; Performance data problems (including lack of historical performance data and best practices for collection of data); Performance of retrieving information such as performance data or tasks and events; and Authentication problems. After attending the viewer should have a much better understanding of how intricate the database is, and of how to minimize the problems that may be experienced in normal database operation.

Virtualization Management

Breakout Session

vCenter, Database Architecture

1 Hour

Jonathan McDonald, Sr. Technical Support Engineer, VMware, Inc.