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

Update the Database Config report: show more db properties (compatibility level, recovery model, etc); add database_scoped_configurations and VLFs #210

Closed
PiJoCoder opened this issue Jan 6, 2023 · 4 comments
Closed

Update the Database Config report: show more db properties (compatibility level, recovery model, etc); add database_scoped_configurations and VLFs #210

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

Comments

@PiJoCoder
Copy link
Collaborator

SELECT name, value
FROM sys.database_scoped_configurations
@PiJoCoder PiJoCoder self-assigned this Jan 6, 2023
@PiJoCoder PiJoCoder added the wave 2 - complete consider this issue for next wave of fixes label Jan 6, 2023
@PiJoCoder
Copy link
Collaborator Author

Add size of the data and log files

@PiJoCoder
Copy link
Collaborator Author

PiJoCoder commented Jan 11, 2023 •
edited

VLF information when available - depends on logs collected by PSSDIAG or LogScout

@PiJoCoder PiJoCoder changed the title Update the Database Config and Properties report to show more db properties (like compatibility level , CE level) and database_scoped_configurations Update the Database Config report to show more db properties (like compatibility level , recovery model) and database_scoped_configurations Jan 31, 2023
@PiJoCoder
Copy link
Collaborator Author

Added compat level, recovery model, database_id,
Also added colors to headings, removed expansion of additional properties (all is visible)
Also added database scoped configuration tablix

image

image

image

PiJoCoder added a commit that referenced this issue Jan 31, 2023
@PiJoCoder
#210 update database properties report with more columns, properties
c4f74b6
PiJoCoder added a commit that referenced this issue Jan 31, 2023
@PiJoCoder
#210 adding a where clause to scoped configuration query to show data…
abaf5b9 
… from shutdown only
@PiJoCoder PiJoCoder mentioned this issue Feb 3, 2023
Merged
@PiJoCoder PiJoCoder changed the title Update the Database Config report to show more db properties (like compatibility level , recovery model) and database_scoped_configurations Update the Database Config report: show more db properties (compatibility level, recovery model, etc); add database_scoped_configurations and VLFs Feb 5, 2023
PiJoCoder added a commit that referenced this issue Feb 5, 2023
@PiJoCoder
Add a new Database Long Info VLF tablix on the DB Properties report #210
f5dcebb
@PiJoCoder
Copy link
Collaborator Author

PiJoCoder commented Feb 5, 2023 •
edited

Added a new table in the report on Db Log Info - VLFs

image

image

PiJoCoder added a commit that referenced this issue Feb 5, 2023
@PiJoCoder
#210 minor correction of column width of VLF report
41c60ee
PiJoCoder added a commit that referenced this issue Feb 6, 2023
@PiJoCoder
Fixing visual issues with DB scoped config report, filter drivers T-S…
17590c4 
…QL bug and typo #210
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