Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Transport queue size query causes entire system degradation #1846

Closed
DavidBoike opened this issue Dec 13, 2019 · 0 comments · Fixed by #1860
Closed

SQL Transport queue size query causes entire system degradation #1846

DavidBoike opened this issue Dec 13, 2019 · 0 comments · Fixed by #1860
Labels
Bug
Milestone

Comments

@DavidBoike
Copy link
Member

@DavidBoike DavidBoike commented Dec 13, 2019

Description

ServiceControl's QueueLengthProvider for SQL Transport uses an individual select count(*) from table which causes problems when a given queue gets too big:

  1. The query begins to time out.
  2. The information presented in ServicePulse monitoring is wrong (0) when the query times out.
  3. Increased load on the SQL Server database (as the query happens repeatedly, constantly running clustered index scans) that degrade the performance of the entire system.

Plan of action

@tmasternak tmasternak added the Bug label Feb 10, 2020
@tmasternak tmasternak changed the title Inefficient SQL Transport queue size query causes entire system degradation SQL Transport queue size query causes entire system degradation Feb 10, 2020
@tmasternak tmasternak added this to the 4.5.3 milestone Feb 10, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

2 participants
You can’t perform that action at this time.