Article Library, Page 7
Every Red9 article in one place, most recently updated first. Written by the senior DBAs who do the work.
- articles
- 220
- categories
- 6
All Articles
Guide · SQL Server Performance TuningHow Many CPUs Is Your SQL Server Able to Use?SQL Server may be ignoring cores you paid for, from licensing limits to offline schedulers. How to check how many CPUs it actually uses, and why.
Guide · SQL Server Performance TuningHow Can You Find the SQL Server Jobs That Start Simultaneously?Multiple SQL Server Agent jobs are configured to start simultaneously, so they run more slowly than they would without the overlap.
Guide · SQL Server Performance TuningHardware and Performance Tuning in SQL ServerStruggling with slow SQL Server performance? It’s probably your disk! Learn why and how to fix it for faster, smoother databases.
Guide · SQL Server Performance TuningImprove Your SQL Server Performance Enabling Data CompressionSQL Server data compression trades CPU work for fewer reads. Find tables and indexes worth checking, and weigh storage savings against the CPU cost.
Guide · SQL Server Health CheckDisabling Windows “Visual Effects” to Boost PerformanceWindows spends CPU and memory on visual effects a database server never uses. Turn them off in two minutes to hand those resources back to SQL Server.
Guide · SQL Server Health CheckDisable Unnecessary SQL Server Instances and ServicesUnused SQL Server services can still consume resources. Find installed instances and services, then check which ones your server actually needs.
Guide · SQL Server Performance TuningDatabase Engine Tuning Advisor (DTA) in Microsoft SQL ServerGood database design improves performance. Proper table indexing and use of those indexes are critical to database performance.
Guide · SQL Server Health CheckBest Practices for the SQL Server Error LogIt’s a file SQL Server uses to log events such as backups, stack dumps, and other informational events.
Guide · SQL Server Health CheckFinding User Tables in SQL Server System DatabasesUser tables in SQL Server system databases can be forgotten during a migration. Find misplaced tables and review the backup and access risks.
Guide · SQL Server Performance Tuning[Full Guide] What Are SQL Server Heap Tables and How to Find ThemDiscover what heap tables are and why they matter in SQL Server. Follow our guide to find and optimize heap tables for better performance.
Guide · SQL Server Health CheckFail-Safe Operator for SQL Server AgentA fail-safe operator is a backup user who receives the alert if the designated operator cannot be reached.
Guide · SQL Server Health CheckEnabling Lock Pages in Memory for SQL ServerIt is a security setting that allows accounts to keep data in physical memory, instead of paging it to disk.
Guide · SQL Server Health CheckDisabling Windows Automatic UpdatesControl Windows automatic updates on SQL Server hosts. This older guide covers manual update settings and patching during maintenance windows.
Guide · SQL Server Health CheckTop Tips for Optimal Performance After SQL Server InstallationReview SQL Server post-installation settings for TempDB, memory, MAXDOP, autogrowth, database paths, patching, and TCP/IP connectivity.
Guide · SQL Server Security[Security Best Practices] SQL Server on Amazon RDSSecure your SQL Server on Amazon RDS with IAM, VPC subnet control, auditing, and encryption (KMS, TDE, SSL). Follow these proven best practices.
Guide · SQL Server TipsChoosing the Right Azure SQL Service Database: A Complete GuideIn the recent past, Microsoft introduced Azure SQL, bringing all the SQL Server products in one suite.
Guide · SQL Server Performance TuningHow Triggers Affect Your SQL Server PerformanceTriggers can slow your SQL performance down or they can be a savior in some admin tool. See when to use them, when not and more.
Guide · SQL Server Performance Tuning7 T-SQL Development Tips for Faster QueriesI share some essential techniques that never change to make your queries run faster in Microsoft SQL Server.
Guide · SQL Server Performance TuningPerformance Tuning Techniques for SQL Server Replication17 ways to speed up SQL Server transactional replication, from the distribution database to pull subscriptions and Distribution Agent settings.
Guide · SQL Server Health Check“Optimize for Ad Hoc Workloads” Option and SQL PerformanceThe Optimize for Ad Hoc Workloads setting stops one-off queries from bloating your plan cache. When to enable it, and the memory it frees up.
Guide · SQL Server TipsMicrosoft SQL Server License Guide: Complete BreakdownConfused by SQL Server licensing? This 2025 guide breaks down core vs. CAL models, cloud rules, editions, and pricing to help you license SQL right.
Guide · SQL Server Performance TuningSQL Server Performance Tuning Using IndexesSQL Server indexes can speed reads and slow writes. See how clustered, nonclustered and covering indexes affect filters, joins and query performance.
Guide · SQL Server TipsResources to Microsoft SQL ServerDiscover a comprehensive list of free resources for Microsoft SQL Server. Download now and enhance your database management skills.
Client Result · SQL Server Performance TuningHow One Index Cut 60 Minutes of Daily SQL Server Wait TimeA stored procedure ran about 11,500 times a day and waited an hour a day on CPU and memory. One index cut reads per run about 6x and waits went to near zero.
Client Result · SQL Server Performance TuningHow Removing One MAXDOP Hint Made a Query 5.5 Times FasterA stored procedure had been refactored, but an old MAXDOP hint stayed behind. Removing it cut the run from 2,933 ms to 531 ms.
Client Result · SQL Server Performance TuningHow One Index Cut a Stored Procedure's Disk Reads 35 TimesA stored procedure that ran hundreds of times a day read about 350,000 pages on every run. One non-clustered index cut that to about 10,000.
Client Result · SQL Server Performance TuningHow Index Tuning Cut SQL Server Deadlocks by 73%Deadlocks fell from about 7 a day to 2 after index tuning. Here are the daily numbers, one example fix, and three root causes indexes could not solve.
Client Result · SQL Server Performance TuningHow We Took SQL Server CPU From 100% to 1%An emergency call: queries timing out and CPU at 100% several times a day. One query scanning a table with 43 indexes was behind it. Here is what we changed.