Add Pester V5 Instance Level Checks
SQLDBAWithABeard opened this issue · 2 comments
SQLDBAWithABeard commented
Add new v5 checks using the initfields method to gather the information in the most efficient manner for each of the Instance Unique checks - Validating that the performance is improved and the results are the same as the v4 existing checks using the
https://github.com/dataplat/dbachecks/blob/pesterv5/Get-AllInstanceInfo%20testing.ps1 as an example
Here are the checks that use SpConfigure running in v5
pesterv5running.mp4
Invoke-DbcCheck Performance improvement running in v5 and with AllInstanceInfo Improvements
invokedbccheckperf.mp4
Improving AllInstanceInfo performance
allinstancinfo.mp4
- AdHocDistributedQueriesEnabled
- AdHocWorkload
- ADUser
- AgentServiceAdmin
- BackupPathAccess
- BuiltInAdmin
- CLREnabled
- CrossDBOwnershipChaining
- DAC
- DefaultBackupCompression
- DefaultFilePath
- DefaultTrace
- EngineServiceAdmin
- ErrorLog
- ErrorLogCount
- FullTextServiceAdmin
- HideInstance
- InstanceConnection
- LatestBuild
- LinkedServerConnection
- LocalWindowsGroup
- LoginAuditFailed
- LoginAuditSuccessful
- LoginCheckPolicy
- LoginMustChange
- LoginPasswordExpiration
- MaxDopInstance
- MaxMemory
- MemoryDump
- ModelDbGrowth
- NetworkLatency
- OLEAutomation
- OLEAutomationProceduresDisabled
- OrphanedFile
- PublicPermission
- RemoteAccessDisabled
- SaDisabled
- SaExist
- SaRenamed
- ScanForStartupProceduresDisabled
- ServerNameMatch
- SqlAgentProxiesNoPublicRole
- SqlBrowserServiceAccount
- SqlEngineServiceAccount
- SQLMailXPsDisabled
- SupportedBuild
- SuspectPageLimit
- TempDbConfiguration
- TraceFlagsExpected
- TraceFlagsNotExpected
- TwoDigitYearCutoff
- WhoIsActiveInstalled
- XESessionRunning
- XESessionRunningAllowed
- XESessionStopped
- XpCmdShellDisabled
SQLDBAWithABeard commented