Only real time performance data is displayed in vCenter 4.1

This issue is resolved in vSphere 5.0. 

Because vCenter Server 4.1 runs on a 64bit operating system and SQL 2008 has a larger capacity, you may want to download and use the SQL Express 64bit version. 
However when using vCenter Server 4.1 with SQL Express 64bit, there is an issue where the vCenter Server performance rollup stored procedures are not called.
To check the version of the SQL engine:

1. Use SQL Management Studio to connect to the SQL database for vCenter Server.

2. Select New query .

3. Enter this query in the new query window and click Execute.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') 


4. Verify that you see output similar to:

10.0.1600.22 RTM Express Edition (64-bit)
10.50.1600.1 RTM Express Edition with Advanced Services

This output indicates the version of the database is 64bit and as a result of this, vCenter Server fails to run the rollup stored procedures.

To resolve this issue, VMware recommends upgrading to vSphere 5.0.

Alternatively. on vSphere releases prior to vSphere 5.0, migrate the SQL database to a full edition (32bit or 64bit) or a 32bit SQL Express edition.

No comments:

Post a Comment