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

Improve or create more Best Practices Rules: loaded modules, spinlocks, optimizer timeout, deadlock TF, trace warning, huge grant #215

Closed
PiJoCoder opened this issue Jan 21, 2023 · 2 comments
Closed

Improve or create more Best Practices Rules: loaded modules, spinlocks, optimizer timeout, deadlock TF, trace warning, huge grant #215

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

Comments

@PiJoCoder
Copy link
Collaborator

PiJoCoder commented Jan 21, 2023 •
edited

usp_HugeGrant
usp_ExcessiveTrace_Warning
usp_WarnmissingIndex
usp_DeadlockTraceFlag
usp_OptimizerTimeout
usp_Spinlock_HighCPU
usp_NonMS_LoadedModules
@PiJoCoder PiJoCoder self-assigned this Jan 21, 2023
@PiJoCoder PiJoCoder added the wave 2 - complete consider this issue for next wave of fixes label Jan 21, 2023
@PiJoCoder PiJoCoder changed the title Improve more Best Practices Rules - perf, messages reported, etc. Improve or create Best Practices Rules - perf, messages, URLs, etc. Jan 21, 2023
PiJoCoder added a commit that referenced this issue Jan 21, 2023
@PiJoCoder
Updated or created best practices rules (grants, exc trace, missing i…
8812bef 
…dx, deadlck tf, opt timeout) #215

usp_HugeGrant
usp_ExcessiveTrace_Warning
usp_WarnmissingIndex
usp_DeadlockTraceFlag
usp_OptimizerTimeout
@PiJoCoder
Copy link
Collaborator Author

Also this commit bffaf12

PiJoCoder added a commit that referenced this issue Jan 22, 2023
@PiJoCoder
#215 Optimizer timeout rule completed
092c5e9
PiJoCoder added a commit that referenced this issue Jan 24, 2023
@PiJoCoder
#215 improve the best practices report background color - footer and …
56ebbc9 
…header
PiJoCoder added a commit that referenced this issue Jan 25, 2023
@PiJoCoder
Update color scheme to Best practices report - #215
23af31b
PiJoCoder added a commit that referenced this issue Jan 29, 2023
@PiJoCoder
Added new rule for Spinlock stats #215
6ec0755
@PiJoCoder PiJoCoder changed the title Improve or create Best Practices Rules - perf, messages, URLs, etc. Improve or create Best Practices Rules, improve perf, messages, URLs, etc. Jan 30, 2023
PiJoCoder added a commit that referenced this issue Jan 31, 2023
@PiJoCoder
#215 added rule for Loaded Modules and enabled Loaded Modules report …
eb6133b 
…to run
@PiJoCoder PiJoCoder changed the title Improve or create Best Practices Rules, improve perf, messages, URLs, etc. Improve or create more Best Practices Rules: loaded modules, spinlocks, optimizer timeout, deadlock TF, trace warning, huge grant Jan 31, 2023
@PiJoCoder
Copy link
Collaborator Author

PiJoCoder commented Feb 1, 2023 •
edited

image

image

image

image

@PiJoCoder PiJoCoder mentioned this issue Feb 3, 2023
Merged
PiJoCoder added a commit that referenced this issue Feb 4, 2023
@PiJoCoder
Adding another CRLF to optimizer timeout rule #215
28793d6
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@PiJoCoder PiJoCoder

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

No branches or pull requests
1 participant
@PiJoCoder