VMware Cloud Community
hodhod26
Contributor
Contributor

Sql database Grown Rapdidly

we have vcenter 4 and i notice that the database is grown rapidly in the last 2 weeks. it is grown about 10G daily.

is there any reason for this grown.

Regards.

Reply
0 Kudos
8 Replies
mittim12
Immortal
Immortal

Did you increase your vCenter statistical level?

Sent from my iPhone

Reply
0 Kudos
hodhod26
Contributor
Contributor

no i didn't.

Reply
0 Kudos
krowczynski
Virtuoso
Virtuoso

Hi,

is it an SQL Express or an full SQL Edition.

Try to take a full and a transaction backup daily and monitor if the database stiil grow up.

MCP, VCP3 , VCP4
Reply
0 Kudos
hodhod26
Contributor
Contributor

It is full SQL server 2008.

Reply
0 Kudos
AndreTheGiant
Immortal
Immortal

Is the data file that is growing or the log file?

Which log level have you set in statistics?

PS: thread has been moved to vCenter forum.

Andre

Andrew | http://about.me/amauro | http://vinfrastructure.it/ | @Andrea_Mauro
Reply
0 Kudos
admin
Immortal
Immortal

Is this a large scale enterprise deployment ? How many hosts and VMs do you have on the VC? Nevertheless, 10 Gigs per day sounds alarming.

Reply
0 Kudos
hodhod26
Contributor
Contributor

I have 16 ESX with 200 vdi VMs and 20 Running servers.

the statistics level 4.

but i want to say that the database size in the last 2 years was 6G, this grown beging  from 2 weeks or 3 weeks without any reason i know.

Reply
0 Kudos
AndreTheGiant
Immortal
Immortal

Statistics level is TOO high.

Put to 2 or 1 (for month and year).

Andre

Andrew | http://about.me/amauro | http://vinfrastructure.it/ | @Andrea_Mauro
Reply
0 Kudos