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')
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.
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