Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizing deletion in batch
Message
De
10/01/2014 13:34:27
 
 
À
10/01/2014 12:29:39
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
Application:
Web
Divers
Thread ID:
01591061
Message ID:
01591659
Vues:
31
>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.

We are talking about a very huge environment so there isn't any flexibilty of moving anything out of it.

But, thanks for the info
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform