Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>That is the classic behavior of the oplocks. It starts out giving the only user "exclusive" access. When the second user joins, the first users exclusive changes to shared. Then all users are equally slow. THAT is the normal. Exclusive use is an exceptional case and you will never get that performance across the shared users. The best thing is to disable oplocks and optimize for shared access. 15 seconds may be something you can really cut down on.
>
Mike, is there a way to programattically determine if oplocks is on/off?
Is it your experience that turning off oplocks has a particular success rate for improving performance? Usually? 50/50?
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