>>Did you try to set the recovery model of the database to simple?
>
>Yes
>
>>Also did you consider to put your database on an SSD drive?
>
>I wouldn't think this is possible presently in regards to this new hardware used in the virtual environment.

I would not put any heavy duty database in a virtual environment. It deserves it own wel equipped box. There are many challenges with virtual environments in regards of I/O, I'm currently battleing one myself where there are TCP/IP problems.

If you could just check whether performance is ok on a non-virtualized box. If it is, just get the database out of the virtualized environment and put it on its own box.

If you have no choice, I'd call for a VMWare expert to look at your config and make sure that the I/O performance is optimal. Just a simple VM environment is not going to cut it. For databases to perform wel you need to take it a step further like raw mapping of disks or using fibre iSCSI solutions to SAN environments.

It might be a lot cheaper to put things on a dedicated box with or without enterprise class SSD disks.

Walter,