| Product(s): | APM Implementation and Performance Management | ||
| Version(s): | All | ||
| Environment: | SQL Server 16+ | ||
| Area: | database | ||
| Subarea: | N\A |
Problem
While using the software users are getting disconnected and having to reconnect. This is happening to all users, software is also taking a lot of time to load screens. (Very sluggish)
Seeing multitude of deadlocks database side, seemed very similar to descriptions of Excessive parallelism :
Solution
This case was in a SQL Azure instance which had been super sized to do an restore and upgrade and was recently scaled back in allocated DTUs, sized for normal operation.
Setting MaxDOP = 8, changed from 0, per recommendation in MS article, did reduced the concurrent activity on the database to a manageable level for the APM application.
See Also
SR 7001490329