Checks whether lightweight pooling is disabled on the server. Setting lightweightpooling to 1 causes SQL Server to switch ...

Checks whether lightweight pooling is disabled on the server. Setting lightweightpooling to 1 causes SQL Server to switch to fiber mode scheduling. Fiber mode is intended for certain situations when the context switching of the UMS workers are the critical bottleneck in performance. Because this situation is unusual, fiber mode rarely enhances performance or scalability on the typical system.

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. ... Checks whether SQL Server 2000 system tables can be updated. We recommend that you do not allow system tables to be updated. ... Checks whether SQL Server 7.0 or SQL Server 7.0 OLAP Services is installed. Server Server 2008 is not supported with SQL ...