Category: Performance Item: Default Max degree of parallelism The max degree of parallelism option is used by SQL Server to limit the number of processors

Category: Performance Item:  High VLF count What is a Virtual Log File (VLF)? The transaction log file is physically divided internally into several virtual log

Category: Reliability Item: SQL Engine startup settings What are SQL Server startup parameters? When you install SQL Server, setup writes a set of default startup

Category: Performance Item:  Trace flags What is a Trace Flag in the SQL server? SQL Server trace flags are configuration handles that can enable or

Category: Reliability Item:  SIMPLE recovery model usage What is the SIMPLE recovery model in SQL Server? Simple Recovery Model is the basic recovery model available

Category: Reliability Item:  Page Verification not optimal What is Page verify in SQL Server? Page Verify is a database option that defines the mechanism used by SQL

Category: Reliability Item:  Remote DAC Disabled What is the DAC SQL Server? It’s a diagnostic connection for a database administrator to access SQL. The DAC can

Category: Performance Item:  Windows Power plan CPU performance and Windows power plans Usually, the balanced power plan is set by default, which is what Microsoft

Category: Reliability Item:  No failsafe operator What is a fail-safe operator in SQL Server? A fail-safe operator is a backup user who receives the alert

Category: Reliability Item: DBCC Shrink ran recently What is shrinking a database in SQL? Shrinking data files recovers space by moving pages of data and

Category: Performance Item:  Default max memory setting. Why should you care about max memory in SQL Server? SQL RAM max memory default setting is terrible.

Category: Reliability Item:  File growth options What is Database Autogrowth in the sql server? It’s a procedure used by the SQL Server engine to expand