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
Why should you care about SQL Agent job’s owner?
SQL Agent jobs owned by non-SA account Users leave the organization. When login is disabled, deleted or Active Directory is not available – the job
SQL Server – priority boost option
Priority boost is ON What does priority boost option do? The option will make SQL Server run the sqlservr.exe process and threads as High Priority. It has
Best practices for SQL Server statistics
Auto-Update Statistics What are statistics in SQL Server? They are large binary objects (BLOBs) that contain information about the correlation and distribution of values in
Optimal Window’s OS page file settings for SQL Server
Windows OS page file not optimal What is the Windows OS page file? This file is a form of virtual memory. When your memory ram becomes full,
What is the MAXDOP setting in SQL Server?
Default “Max degree of parallelism” (MAXDOP) The max degree of parallelism option is used by SQL Server to limit the number of processors to use
How high Virtual Log File (VLF) counts kill your SQL Performance
High Virtual Log File (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
SQL Engine startup settings What are SQL Server startup parameters? When you install SQL Server, setup writes a set of default startup options in the
Trace flags in SQL Server
What are Trace Flags in SQL Server? SQL Server trace flags are configuration handles that can enable or disable a specific SQL Server characteristic or
SIMPLE recovery model in SQL Server
SIMPLE recovery model usage What is the SIMPLE recovery model in SQL Server? Simple Recovery Model is the basic recovery model available in SQL Server.
SQL Server page verification CHECKSUM
Page Verification not optimal What is Page verify in SQL Server? Page Verify is a database option that defines the mechanism used by SQL Server to verify
SQL Server Remote Dedicated Admin Connection (DAC)
Remote DAC Disabled What is the DAC Connection SQL Server? It’s a diagnostic connection for a database administrator to access SQL. The DAC can make remote
Optimal Windows Power Plan for SQL Server
Windows Power Plan CPU performance and Windows power plans Usually, the balanced power plan is set by default, which is what Microsoft recommends for general