Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Everything slows down when one user runs query
Message
From
01/10/2018 15:39:28
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Optimization
Title:
Everything slows down when one user runs query
Environment versions
SQL Server:
SQL Server 2016
OS:
Windows 10
Network:
Windows Server 2012 R2
Miscellaneous
Thread ID:
01662422
Message ID:
01662422
Views:
49
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
Next
Reply
Map
View

Click here to load this message in the networking platform