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 parameter -CacheTop to retrieve more/less than the top 10 queries from the plan cache - only usable for HTML output #134

Closed
VladDBA opened this issue Nov 9, 2023 · 0 comments · Fixed by #142
Closed

Add parameter -CacheTop to retrieve more/less than the top 10 queries from the plan cache - only usable for HTML output #134

VladDBA opened this issue Nov 9, 2023 · 0 comments · Fixed by #142
Assignees
@VladDBA
Labels
enhancement New feature or request

Comments

@VladDBA
Copy link
Owner

VladDBA commented Nov 9, 2023

New parameter -CacheTop which controls the number of Top X queries retrieved from the plan cache by sp_BlitzCache.
The new parameter will only be accessible via script mode, in interactive mode it will always default to 10, and will be valid only for HTML output, since that's dynamic in terms of table sizes.
@VladDBA VladDBA added the enhancement New feature or request label Nov 9, 2023
@VladDBA VladDBA self-assigned this Nov 9, 2023
@VladDBA VladDBA changed the title Add parameter -CacheTop to retrieve more/less than the top 10 queries from the plan cache - only for HTML outpu Add parameter -CacheTop to retrieve more/less than the top 10 queries from the plan cache - only usable for HTML output Nov 9, 2023
@VladDBA VladDBA mentioned this issue Nov 14, 2023
Merged
@VladDBA VladDBA closed this as completed Nov 14, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@VladDBA VladDBA

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Dev VladDBA/PSBlitz
1 participant
@VladDBA