Checks whether default trace is turned on to collect information about configuration and DDL changes to the instance of SQL Server. This information can be helpful for customers and Microsoft Technical Support when troubleshooting issues with the Database Engine.
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 ...
Checks whether default trace is turned on to collect information about configuration and DDL changes to the instance of SQL ...
Checks whether enforce password expiration on SQL Server logins is enabled. Enforce password expiration should be enabled ...
Checks whether for the value specified for network packet size server option is set to the optimal value of 8060 bytes. If ...
Checks whether hotfix KB937444 is installed. This is required for FILESTREAM to work on a Windows Server 2003-based cluster. ...
Checks whether lightweight pooling is disabled on the server. Setting lightweightpooling to 1 causes SQL Server to switch ...