I've upgraded from Virtual Center 2.5 to Vcenter 4.0 and since the upgrade our SQL transaction LOG file keeps filling up, we are having to do backups every two hours just to keep the LOG file from filling up. we have a MAX size of 750MB for the LOG file. the VIM_VCDB is 740MB in size.
I am running SQL 2005 express edition, It is managing approx 10 ESX 3.5 hosts and about 150 guests.
Currently, the LOG file size is 739MB and is 79% used and I just took a backup approx 1 hour 20 min ago. I have confirmed that after the backup the LOG file used space goes back down to 1%.
has anyone else encountered this issue... Any ideas as to why something is not commiting.. I have disabled statistics in Vcenter, but still did not resolve this issue. I have a support case in with VMWARE right now; but they are saying that they don't support SQL LOG files. and there response is Increase the LOG file size.. I understand from a basic point about LOG file management but I feel this amount of un-commited transactions is just to excessive and there has to be something misconfigured or just plain not working right.
Any thoughts would be appreciated.
