The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
VPXD randomly fails when statistics level is set to 3 or higher and the database load is too heavy with many long-run transactions (1017605)
VirtualCenter Server encounters SQL Server performance problems.
The VirtualCenter Server service disconnects when the database load is heavy with many long-run transactions and the VirtualCenter statistics collection is set to level 3 or higher for one or more statistics intervals for more than 20 minutes.
The VirtualCenter Server vpxd logs in %ALLUSERSPROFILE%\Application Data\VMware\VMware VirtualCenter\Logs\ display the following or similar error message:
[2009-02-12 09:42:18.932 'App' 7556 error] An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Check database connectivity before restarting. Error: Error[VdbODBCError] (-1) "ODBC error: (HY000) - [Microsoft][SQL Native Client][SQL Server]The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions." is returned when executing SQL statement "UPDATE VPX_VM SET DATACENTER_ID = ? , HOST_ID = ? , RESOURCE_GROUP_ID = ? , POWER_STATE = ? , DISABLED_SNAPSHOT = ? , FAILED_DMOTION = ? , IS_TEMPLATE = ? , AGENT_ID = ? , AGENT_CNX_STATE = ? , FILE_NAME = ? , LOCAL_FILE_NAME = ? WHERE ID = ?"
[2009-02-12 09:42:18.932 'App' 7556 info] Forcing shutdown of VMware VirtualCenter now
The HY000:1204 error with description "ODBC error: (HY000) - [Microsoft][SQL Native Client][SQL Server]The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time."
Improvements in VMware VirtualCenter Server 2.5 Update 6 prevent VirtualCenter Server failures by retrying the failure operations. However, if the VirtualCenter Server database is still under extreme load, failures might occur. For example, 200 ESX hosts and 2000 virtual machines with all statistics levels set to 4 is considered an extreme load.
For information about statistics levels and how to configure them, see the:
- VirtualCenter 2.5: Chapter 18 of the Basic Administration Guide.[PDF]
- vCenter Server 4.0.x: Chapter 22 of vSphere Basic System Administration. [PDF]
If your VirtualCenter Servers SQL database is under heavy load and all measures have been taken with VMware support to improve performance, you may consider moving to a 64-bit SQL Server since it can perform better in a symmetric multiprocessor (SMP) environment. For more information, see the SQL Server Performance in a VMware Infrastructure 3 Environment.
Request a Product Feature
To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.