The Red9 Blog
Get our new tips before anyone else. Enter your email below to join our private list!
Most Popular Red9 Posts
Latest From Red9
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