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
What is the MAXDOP setting in SQL Server?
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
How high VLF counts kill your SQL Performance
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
SQL Server startup parameters
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
Trace flags in SQL Server
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
SIMPLE recovery model in SQL Server
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
SQL Server page verification CHECKSUM
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
SQL Server remote dedicated admin connection (DAC)
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
Optimal power plan for SQL Server
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
Fail-safe operator for SQL Server agent
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
Best practices for the SQL Server shrink
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
SQL Server max memory parameter
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.
Best practices to set database auto growth size on SQL server
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