Health Checks
By health checks, I’m referring to checks that run periodically against the databases. DBCC procedures/ANALYZE VALIDATE might be part of these checks. First, you will want to run health checks immediately after creating the database—if the database does not start off in a good state with all of the pieces that it is expecting, how is it going to be maintained? It’s also a good idea to run health checks when taking over support for an existing system.
Health checks include validating the proper permissions for the administrator accounts, scheduling backups, scheduling maintenance jobs, checking the version of the database and patches, and checking options and parameters. This list might sound like tasks you perform after creating ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
