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

PSBlitz.ps1 - warning and behavior changes for instances with over 50+ databases #279

Closed
VladDBA opened this issue Nov 12, 2024 · 0 comments · Fixed by #284
Closed

PSBlitz.ps1 - warning and behavior changes for instances with over 50+ databases #279

VladDBA opened this issue Nov 12, 2024 · 0 comments · Fixed by #284
Assignees
@VladDBA
Labels
enhancement New feature or request

Comments

@VladDBA
Copy link
Owner

VladDBA commented Nov 12, 2024 •
edited
Loading

In case of an instance-wide check do the following:

  • check the number of user databases
  • if the number of user databases => 50 then:
    • restrict spBlitzIndex_NonSPLatest.sql to the database that shows up the most times in cache results
    • inform the user of the above change
@VladDBA VladDBA added the enhancement New feature or request label Nov 12, 2024
@VladDBA VladDBA self-assigned this Nov 12, 2024
VladDBA added a commit that referenced this issue Nov 16, 2024
@VladDBA
partial changes for #279
36c5108
VladDBA added a commit that referenced this issue Nov 16, 2024
@VladDBA
partial changes for #279
80afb19
VladDBA added a commit that referenced this issue Nov 17, 2024
@VladDBA
partial changes for #279
2c94a07
VladDBA added a commit that referenced this issue Nov 17, 2024
@VladDBA
more changes for #279, #280
1085011
VladDBA added a commit that referenced this issue Nov 17, 2024
@VladDBA
for #277 #115 #280 #279
6d55cc8
@VladDBA VladDBA mentioned this issue Nov 20, 2024
Merged
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 - 3AM PR - aka some people really live with 100+ databases on one instance VladDBA/PSBlitz
1 participant
@VladDBA