After we upgraded our ESX3 VI Client server to the new Vsphere4 I have found (the hard way!http://communities.vmware.com/images/emoticons/shocked.gif!) that our SQL tempdb size was growing out of control (gig's per minute)... It did not help matters that the SQL Server is on a seperate box than the VI Client server, where a number of hosted databases live. After shutting down SQL several times to clear the tempdb and try and track which DB was the culprit.. I have found that the tempdb growth seems to be related to a SQL job called "Past Day stats rollupVirtualCenter" (VirtualCenter happens to be the name of our VSphere4 VC database). As soon as I found and stopped this job on our SQL server the growth of the tempdb stopped.
Does anyone know if this job is critical and/or why it would be causing the SQL server tempdb to grow until it fills the disk. I have the job stopped and disabled until I find a resolution.
If anyone else has experienced this or has any ideas as to the importance of this job and what it does for VSphere, please let me know. I am sure its there for a purpose.
Thanks,