Skip to content

Improve MSSQL (Part III) #20230

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

Merged
merged 9 commits into from
May 13, 2025
Merged

Conversation

thiagoftsm
Copy link
Contributor

@thiagoftsm thiagoftsm commented May 3, 2025

Summary

When running on busy servers, or computer with slow memory, it was observed gaps on charts. To address this issue, we are isolating the queries in a thread.

This PR also fixes a small issue when running on SQL Express. Previously, if a variable was not initialized, strange values could appear.

Update metdata.

This PR also does small cleanup and renames to keep a pattern.

Test Plan
  1. Compile this branch.
  2. Install it on a host running SQL server
  3. Configure your netdata.conf as shown in metadata..
Additional Information

This PR was tested with SQL Server 2022 and SQL Server Express 2019.

For users: How does this change affect me?

@thiagoftsm thiagoftsm requested a review from stelfrag May 3, 2025 04:21
@github-actions github-actions bot added area/collectors Everything related to data collection collectors/windows labels May 3, 2025
@thiagoftsm thiagoftsm marked this pull request as draft May 5, 2025 12:17
@thiagoftsm thiagoftsm force-pushed the split_collection branch 3 times, most recently from ef28a32 to b27b4b7 Compare May 12, 2025 01:11
@github-actions github-actions bot added the area/metadata Integrations metadata label May 12, 2025
@thiagoftsm thiagoftsm marked this pull request as ready for review May 12, 2025 02:18
@ilyam8
Copy link
Member

ilyam8 commented May 13, 2025

it was observed gaps on charts

What charts?

@thiagoftsm
Copy link
Contributor Author

it was observed gaps on charts

What charts?

I observed these issues with the MSSQL metrics, because the system had to query data before plotting. In this PR, I'm separating data collection from plotting, which prevents this issue from recurring on my host.

I haven't observed this behavior in our VMs.

@thiagoftsm thiagoftsm merged commit a78abaa into netdata:master May 13, 2025
108 checks passed
@thiagoftsm thiagoftsm deleted the split_collection branch May 13, 2025 22:29
@ilyam8
Copy link
Member

ilyam8 commented May 14, 2025

because the system had to query data before plotting

What does that mean?

stelfrag pushed a commit to stelfrag/netdata that referenced this pull request May 21, 2025
@stelfrag stelfrag mentioned this pull request May 21, 2025
Ferroin pushed a commit that referenced this pull request May 22, 2025
(cherry picked from commit a78abaa)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/collectors Everything related to data collection area/metadata Integrations metadata collectors/windows
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants