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

microsoft / SqlNexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.

MIT License

348 stars 99 forks source link

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

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

SELECT name, value
FROM sys.database_scoped_configurations

PiJoCoder commented 1 year ago

Add size of the data and log files

PiJoCoder commented 1 year ago

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

PiJoCoder commented 1 year ago

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

PiJoCoder commented 1 year ago

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