Checks the max degree of parallelism option for the optimal value to avoid unwanted resource consumption and performance degradation. The recommended value of this option is 8 or less. Setting this option to a larger value often results in unwanted resource consumption and performance degradation.
Checks that only members of the sysadmins fixed server role can execute CmdExec and ActiveX Script job steps. Applies only ...
Checks that symmetric keys with a length less than 128 bytes do not use the RC2 or RC4 encryption algorithm. The best practice ...
Checks that the AUTO_ CLOSE option is off for SQL Server Standard and Enterprise Editions. When set to on, this option can ...
Checks that the AUTO_SHRINK option is off for user databases on SQL Server Standard and Enterprise Editions. Frequently shrinking ...
Checks the max degree of parallelism option for the optimal value to avoid unwanted resource consumption and performance ...
Checks the max work threads server option for potentially incorrect settings of an instance of SQL Server 2005. Setting the ...
Checks the max worker threads server option for potentially incorrect settings of an instance of SQL Server 2000 that is ...
Checks the max worker threads server option for potentially incorrect settings of an instance of SQL Server 2000 that is ...
Checks whether a database has recent backups. Scheduling regular backups is important for protecting your databases against ...