Checks an instance of SQL Server 2000. Warns if the data file is 1 GB or larger, and is set to autogrow by a percentage, ...

Checks an instance of SQL Server 2000. Warns if the data file is 1 GB or larger, and is set to autogrow by a percentage, instead of growing by a fixed size. Growing a data file by a percentage can cause SQL Server performance problems because of progressively larger growth increments. For an instance of SQL Server 2000, set the FILEGROWTH (autogrow) value to a fixed size to avoid escalating performance problems.

Checking FILESTREAM filegroup "%1!s!" (ID %2!s!) is not supported in DBCC CHECKFILEGROUP. Specify a filegroup containing ... Checking for existence of the SQL Server Browser service account property before applying the SQL Server Browser service ... Checking to see if any previously copied log backup files that are required by the restore operation are missing. Secondary ... Checkpoint file "%1!s!" does not match this package. The ID of the package and the ID in the checkpoint file do not match. ... Checks an instance of SQL Server 2000. Warns if the data file is 1 GB or larger, and is set to autogrow by a percentage, ... Checks an instance of SQL Server for setting, affinity mask to its default value 0, since in most cases, the Microsoft Windows ... Checks an instance of SQL Server having processors that are assigned with both the affinity mask and the affinity I/O mask ... Checks an instance of SQL Server having processors that are assigned with both the affinity64 mask and the affinity64 I/O ... Checks for default surface area settings for Analysis Services features. Only the features required by your application should ...