swica
Contributor
Contributor

vCenter 4.1 TEMPDB growing - high read/writes

After migrating the vCenter DBs to a new physical server (windows 2008 R2 x64) with SQL 2008 SP2, we realized very high read and writes on the SQL TEMPDB and the TEMPDB was growing rapidly. When we stop the vCenter service, the r/w on the TEMPDB fade away.

As a result of the high I/Os and the growing DB, the disk queue was high and the serverresponse very slow until the the TEMPDB fills up the diskspace and the server didn't response.

In our case, the solution was to alter the "Fill Factor for Clustered Indexes" on "Performance Statistics Tables" of the VCDB database (http://www.vmware.com/pdf/vsp_4_vcdb_sql2008.pdf).

After we set the value to 70 (%), the read/writes on the TEMDB fall back to a "normal" amount, no more growing TEMPDB and a diskqueue about 0.1 to 1.0.

The solution is described in the VMware performance study "VMware vCenter 4.0 Database Performance for MS SQL Server 2008" (see the link above).

Another reason/solution for this problem is described in the VMware KB Article 1033925 - but didn't work/help in our case:

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=103392...

0 Kudos
0 Replies