-
Notifications
You must be signed in to change notification settings - Fork 6.1k
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
Improve MSSQL (Part III) #20230
Conversation
ef28a32
to
b27b4b7
Compare
b27b4b7
to
0704282
Compare
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. |
What does that mean? |
(cherry picked from commit a78abaa)
(cherry picked from commit a78abaa)
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
Additional Information
This PR was tested with SQL Server 2022 and SQL Server Express 2019.
For users: How does this change affect me?