Performance statistics rollup from Past Week to Past Month is not occurring in the database

Hi All,

I get this warning when I see it from my VCenter server health status:

Performance statistics rollup from Past Week to Past Month is not occurring in the database

Note:
Database:
Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64)
      Mar 19 2015 12:32:14
      Copyright (c) Microsoft Corporation
      Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

VCenter and vSphere versions:
Versions
So how do I fix this issue ?
LVL 9
Senior IT System EngineerIT ProfessionalAsked:
Who is Participating?
 
Luciano PatrãoConnect With a Mentor ICT Senior Infraestructure  Engineer  Commented:
Hi,

If you are using SQL Express then there is no rollup jobs running in the SQL.

"In MS SQL server 2005/2008/2008 R2 Express Edition, there is no SQL Agent to run the jobs. Instead, the VMware VirtualCenter Server service calls the stored procedures for performing the rollup directly. When the vpxd is running, the calls to run the stored procedures are automatically executed."

Did you upgrade this vCenter?? Or even the SQL?? Or move the DB to another SQL server?

Important: Check the user that you have in the ODBC, if the user doesn't have proper permissions you can have some issues.

Some links:

https://kb.vmware.com/kb/2012226

Follow these SQL queries and see if you can see the issues.

Jail
1
 
Pawan KumarDatabase ExpertCommented:
This is a known issue with VCenter. You can ignore it.

It is resolved in NEXT VERSIONs.

If you want you can download the new version, take it from the URL below.

https://my.vmware.com/web/vmware/info/slug/datacenter_cloud_infrastructure/vmware_vsphere/5_1
1
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Hi Pawan,

According to https://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=2143838

THe VCenter edition build number: 4180647 is the latest vCenter Server 5.5 Update 3e
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Pawan KumarConnect With a Mentor Database ExpertCommented:
0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Hi Pawan,
Since I'm using SQL Express edition, I do this:

Open MS SQL Server Management Studio Express, and then connect to VIM_VCDB, browse to Programmibility >> Stored Procedures and executing these 3 stored procedures in this exact order:
dbo.l.stats_rollup1_proc
dbo.l.stats_rollup2_proc
dbo.l.stats_rollup3_proc

Open in new window


Shrink both the Log files and database file manually from the GUI
Finally, I restarted the vCenter service.

But still the warning exist.

Based on the KB article you posted, there is no unchecked metrics.
0
 
Pawan KumarDatabase ExpertCommented:
Do you have VCenter operation manager ?
0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
No I do nothave it running.
0
 
Pawan KumarDatabase ExpertCommented:
There actually we can check at the Health section. !!
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
This is a VMWare issue, not a Microsoft SQL Server issue. You do not need to do anything on the SQL Server side.
0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Did you upgrade this vCenter??

Yes I have performed the upgrade from 5.1 to 5.5U3 few weeks ago
0
 
Luciano PatrãoICT Senior Infraestructure  Engineer  Commented:
That is one of the issues after we upgrade.
1
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.