Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance and dead lock
Message
De
14/01/2014 06:31:28
 
 
À
13/01/2014 17:30:29
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01591801
Message ID:
01591824
Vues:
47
This message has been marked as a message which has helped to the initial question of the thread.
>The monitoring team reports that SQL server appears to be under-utilized. They say that the disk I/O is higher than the previous environment and it has been confirmed that CPU power is similar. They report however that the database is not fully utilizing the available RAM. Only half of it is presently being utilized. So, they are wondering if this could be the bottleneck.

Make sure that such measurements are taken inside the VM, not on the base host HW. Make sure that disc is at least a dedicated VHD or similar file if not mapping to separate partition or dedicated HW.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform