Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

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)

Details

  • 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."

Solution

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:
 
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.

Keywords

SQL error, statistics level

Update History

10/12/2010 - Added links to documentation re: configuring statistics levels.

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.

Feedback

  • 7 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 7 Ratings
Actions
KB: