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

Add Pester V5 Database Level Checks #884

Open
25 of 48 tasks
jpomfret opened this issue Apr 26, 2022 · 3 comments
Open
25 of 48 tasks

Add Pester V5 Database Level Checks #884

jpomfret opened this issue Apr 26, 2022 · 3 comments
Assignees
@jpomfret
Labels
enhancement help wanted Performance Pester V5
Projects
Pester V5 support and Performance imp...

Comments

@jpomfret
Copy link
Collaborator

jpomfret commented Apr 26, 2022 •
edited

Database level checks need some Pester V5 love
Each check needs rewritten and added to: \checks\Databasev5.Tests.ps1
We will also need to improve performance by reducing the trips to the instance/database and gathering all information in one hit before discovery, similar to initfields in #882

  • AsymmetricKeySize
  • AutoClose
  • AutoCreateStatistics
  • AutoShrink
  • AutoUpdateStatistics
  • AutoUpdateStatisticsAsynchronously
  • CertificateExpiration
  • CLRAssembliesSafe
  • CompatibilityLevel
  • ContainedDBAutoClose
  • ContainedDBSQLAuth
  • DatabaseCollation
  • DatabaseExists
  • DatabaseGrowthEvent
  • DatabaseMailEnabled
  • DatabaseMailProfile
  • DatabaseStatus
  • DatafileAutoGrowthType
  • DisabledIndex
  • DuplicateIndex
  • FileGroupBalanced
  • FKCKTrusted
  • FutureFileGrowth
  • GuestUserConnect
  • IdentityUsage
  • InvalidDatabaseOwner
  • LastDiffBackup
  • LastFullBackup
  • LastGoodCheckDb
  • LastLogBackup
  • LogfileCount
  • LogfilePercentUsed
  • LogfileSize
  • MaxDopDatabase
  • OrphanedUser
  • PageVerify
  • PseudoSimple
  • QueryStoreDisabled
  • QueryStoreEnabled
  • RecoveryModel
  • SuspectPage
  • SymmetricKeyEncryptionLevel
  • TestLastBackup
  • TestLastBackupVerifyOnly
  • Trustworthy
  • UnusedIndex
  • ValidDatabaseOwner
  • VirtualLogFile
jpomfret added a commit that referenced this issue Apr 26, 2022
@jpomfret
working on ValidDatabaseOwner for #884
ae74f95
SQLDBAWithABeard added a commit that referenced this issue Apr 28, 2022
@SQLDBAWithABeard
because Jess #884
6810c13
jpomfret added a commit that referenced this issue May 4, 2022
@jpomfret
add suspectpage test #884
4b46ed2
jpomfret added a commit that referenced this issue May 27, 2022
@jpomfret
working on #884 - add invalid owner and AsymmetricKeySize
b5f6e66
jpomfret added a commit that referenced this issue May 27, 2022
@jpomfret
add autoclose test #884
57cd8dd
jpomfret added a commit that referenced this issue May 27, 2022
@jpomfret
autoclose - #884
c9ced52
jpomfret added a commit that referenced this issue Jun 1, 2022
@jpomfret
#884 - adding VLF.
bc2b135
jpomfret added a commit that referenced this issue Jun 1, 2022
@jpomfret
#884 add log file count check
dbfd172
jpomfret added a commit that referenced this issue Jun 1, 2022
@jpomfret
#884 add auto create stats
ae1344b
jpomfret added a commit that referenced this issue Jun 5, 2022
@jpomfret
#884 add auto stats async check
4f4759a
jpomfret added a commit that referenced this issue Jun 5, 2022
@jpomfret
#884 trustworthy
e16925e
jpomfret added a commit that referenced this issue Jun 5, 2022
@jpomfret
#884 database status
3ea5f4b
@jpomfret jpomfret self-assigned this Jul 10, 2023
@jpomfret jpomfret mentioned this issue Jul 11, 2023
Merged
SQLDBAWithABeard added a commit that referenced this issue Aug 19, 2023
@SQLDBAWithABeard
so that the database checks dont break the PowerBi Add Pester V5 Data…
e2072c7 
…base Level Checks #884
@jpomfret jpomfret reopened this Aug 19, 2023
@jpomfret
Copy link
Collaborator Author

Reopened this issue as there are still checks to be converted

cc @SQLDBAWithABeard - think it closed automatically because you mentioned it in a PR

@SQLDBAWithABeard
Copy link
Collaborator

Hmm, that's odd. Sorry 😂

@SQLDBAWithABeard
Copy link
Collaborator

Ah, yes.

I put some check fixes and then the issue number so it was doing what it thought was right.

Just Rob speak wasn't aligned!!

@jpomfret jpomfret mentioned this issue Aug 27, 2023
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jpomfret jpomfret

Labels
enhancement help wanted Performance Pester V5
Projects
dbachecks - Pester V5 support and Performance improvements
Status: Doing
Pester V5 support and Performance imp...
Doing
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jpomfret @SQLDBAWithABeard