Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
>>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,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement