Checks whether for the value specified for network packet size server option is set to the optimal value of 8060 bytes. If the network packet size of any logged-in user is more than 8060 bytes, SQL Server performs different memory allocation operations. This can cause an increase in the process virtual address space that is not reserved for the buffer pool.
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 ...
Checks whether password policy enforcement on SQL Server logins is enabled. Password policy should be enforced for all SQL ...
Checks whether shared resource DLLs will be updated, causing restarts for clustered SQL Server instances active on this node. ...