Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Everything slows down when one user runs query
Message
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Optimisation
Titre:
Everything slows down when one user runs query
Versions des environnements
SQL Server:
SQL Server 2016
OS:
Windows 10
Network:
Windows Server 2012 R2
Divers
Thread ID:
01662422
Message ID:
01662422
Vues:
50
We have some performance problems with SQL Server. using standard license, SQL Server version 2016, one user is running a report, during executing the query the other user is unable to save the record until the query if finished. This could be understandable if there are perhaps a lot of users and extreme slow queries running, but in this scenario it does not seem to make sense. An enterprise license may give us the possibility to lower the usage for the query, but this seems to be like killing birds with cannons. What else could be the reason for this behavior?
Christian Isberner
Software Consultant
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform