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

Index info changes for Index Usage and Index Diagnostics #293

Closed
VladDBA opened this issue Dec 23, 2024 · 0 comments · Fixed by #298
Closed

Index info changes for Index Usage and Index Diagnostics #293

VladDBA opened this issue Dec 23, 2024 · 0 comments · Fixed by #298
Assignees
Labels
enhancement New feature or request

Comments

@VladDBA
Copy link
Owner

VladDBA commented Dec 23, 2024

In Resources/spBlitzIndex_NonSPLatest.sql

Set a hard 10k record limit for for both Index Usage and Index Diagnostics,
Add another result set that returns the total record count and include it in an Execution Log record if total record count > 10k.

In PSBlitz.ps1

Remove no longer necessary record limiting code from PSBlitz.ps1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
1 participant