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.

Sign up for GitHub

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

Jump to bottom

Add REDO_THREAD_PENDING_WORK to ignorable wait types in reports #251

Closed
PiJoCoder opened this issue Aug 24, 2023 · 2 comments
Closed

Add REDO_THREAD_PENDING_WORK to ignorable wait types in reports #251

PiJoCoder opened this issue Aug 24, 2023 · 2 comments
Assignees
@PiJoCoder
Labels
wave 3 - complete consider this issue for next wave of fixes

Comments

@PiJoCoder
Copy link
Collaborator

SqlNexus/sqlnexus/PerfStatsAnalysis.sql

Line 577 in 7a86cbf

WHEN wait_type IN (

@PiJoCoder PiJoCoder added the wave 3 - complete consider this issue for next wave of fixes label Aug 24, 2023
@PiJoCoder PiJoCoder self-assigned this Aug 30, 2023
@PiJoCoder
Copy link
Collaborator Author

This wait type would be high if no log records coming on the primary.
Confirmed in https://www.sqlskills.com/help/waits/redo_thread_pending_work/ can be ignored

@PiJoCoder
Copy link
Collaborator Author

Before the fix

image

After the fix (same data set)

image

PiJoCoder added a commit that referenced this issue Aug 30, 2023
@PiJoCoder
#251 REDO_THREAD_PENDING_WORK is now ignorable type
9d23a9f
@PiJoCoder PiJoCoder mentioned this issue Nov 13, 2023
Merged
PiJoCoder added a commit that referenced this issue Nov 16, 2023
@PiJoCoder
Multiple SQL Nexus fixes (#250, #251, #238, #254) (#259)
55c649a 
* #250 Add the ability to enable/disable minimization of Command prompt window when Relog is importing data

* #251 REDO_THREAD_PENDING_WORK is now ignorable type

* #238 Implement -B option for ReadTrace importer to enable local server time import

* #254 re-reading all the import options from the user.config file , which were saved because the "Save My Options" is being enabled

* #254 improving the previos code change by using an array and looping through it. Also modified a few option names ot distinguish them

* version bump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@PiJoCoder PiJoCoder

Labels
wave 3 - complete consider this issue for next wave of fixes
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@PiJoCoder