Maintenance Rules

Introduction

This group contains rules related with SQL Server maintenance and administration.

Maintenance Rules

Related Topics

SA0045 : Consider updating statistics as they appear outdated and may mislead the query optimizer

EX0010 : Identify missing indexes using dynamic management views information

EX0011 : Identify inefficient indexes using dynamic management views information

EX0013 : Identify fragmented indexes that need rebuilding or re-indexing

SA0083 : Consider proactively checking the logical and physical integrity of all the objects in the database

SA0084 : Data purity check is not enabled for the current database

SA0086 : Avoid storing database backups on the same volume as the database’s data files

SA0087 : Database has suspect pages and needs to be checked

SA0088 : The last full backup for the database cannot be found on the location where it was initially created

SA0089 : The option has a not recommended value SET which will cause the stored procedure to be recompiled

SA0090 : SQL Server password policy is vulnerable for login

SA0093 : The compatibility level of the database is lower than the SQL Server version default compatibility level

SA0094 : Authentication set to Mixed Mode

SA0099 : The database is using Full Recovery Model, but its last transaction log backup is too old

SA0100 : Database backups are outdated

SA0141 : Database is using Simple Recovery Model

SA0142 : Consider disabling CLR if user assemblies are not used in your environment

SA0143 : Single use Ad-hoc plans are using considerable amount of the procedure cache