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 running on a 32-bit server. Setting the max worker threads option to a small value might prevent enough threads from servicing incoming client requests in a timely manner, and can lead to shortage of threads. Conversely, because each active thread consumes 512 KB on 32-bit servers, setting the option to a large value can waste address space.

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 ... Checks whether Analysis Services is installed as part of a named instance that includes the SQL Server 2000 Database Engine. ... Checks whether data and log files are placed on separate logical drives. Placing both data and log files on the same drive ...