VMware Cloud Community
Rohail2004
Enthusiast
Enthusiast
Jump to solution

vCenter db growth.

My vCenter database is keep growing at the rapid pace.  I have my database retention policy as 60 days,

It is vCenter 4.1 and all the maintenance job running just fine, but I am concerned about the growth.

0 Kudos
1 Solution

Accepted Solutions
6 Replies
piaroa
Expert
Expert
Jump to solution

What are your Statistics interval set to? You can check this under vCenter Server Settings > Statistics.

If this post has been helpful/solved your issue, please mark the thread and award points as you see fit. Thanks!
0 Kudos
Rohail2004
Enthusiast
Enthusiast
Jump to solution

all the Statistics interval is set to 1.

0 Kudos
Troy_Clavell
Immortal
Immortal
Jump to solution

your are running a recovery Model of Simple?

0 Kudos
piaroa
Expert
Expert
Jump to solution

How big is your DB growing, how much does it grow each day/week? How many hosts/VMs are you running?

If this post has been helpful/solved your issue, please mark the thread and award points as you see fit. Thanks!
0 Kudos
Rohail2004
Enthusiast
Enthusiast
Jump to solution

I found tempdb is 9.0GB located under C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

how can i shrink it?

0 Kudos
Troy_Clavell
Immortal
Immortal
Jump to solution

0 Kudos