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
The proper way to setup SQL Server alerts
Category: Reliability Item: Missing alerts Why should you enable SQL Server alerts? Enabling these Alerts can prevent a lot of problems: Potential to miss critical
Why should you enable SQL Server database backup compression by default?
Category: Reliability Item: Backups compression settings What is the backup compression default option? It determines whether the server instance creates compressed backups by default. Backup
Case study – 66x faster!
Description: Problem: Deadlocking. This stored procedure is continuously involved in deadlocking. Solution: A new index. Scan operation can be tuned into becoming a seek (a
Case study – 354x faster!
Description: Problem: This stored procedure runs very frequently (multiple times per minute) and consumes a lot of server resources (CPU, storage reads and duration). Change:
Case study – 562x faster!
Description: Problem: Stored procedure that is run hundreds of times per hour is taking a long time. Change: Multiple changes were made to code inside
Increasing cost threshold for parallelism may improve your SQL Server performance
What is the CTP in SQL Server? The cost threshold for parallelism (CTP) is the setting that controls at what point a SQL Server query
Best practices for the SQL Server ERRORLOG
Category: Performance Item: SQL Server Error logs not optimally What’s the SQL Server error log? It’s a file used by SQL server to write data
Best practices for the SQL Server TempDB
Category: Performance Item: SQL Server Error logs not optimally configured. What is the TempDB database? Tempdb is one of the system databases in Microsoft SQL
Why should you care about SQL Agent job’s owner?
Category: Security Item: SQL Agent jobs owned by non SA account Users leave the organization. When login is disabled, deleted or Active Directory is not available –
SQL Server – priority boost option
Category: Reliability Item: 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
Best practices for SQL Server statistics
Category: Performance Item: Auto-update statistics What are statistics in SQL Server? They are large binary objects (BLOBs) that contain information about the correlation and distribution
Optimal Window’s page file settings for SQL Server
Category: Performance Item: Windows OS page file not optimal What is the Windows OS page file? This file is a form of virtual memory. When your memory