Every SQL Server workload is different and modest variations to its configuration can have a startling impact on functionality. I like this PowerShell library for DBAs. Rather than create a lot about this right here, https://xanderbzbk210238.blogdon.net/sql-server-health-check-consulting-service-no-further-a-mystery-46171596