SQL Server Performance Tuning
Performance Tuning Tips & Best Practices.
Most Popular Posts
SQL Server Performance Tuning SQL Server Performance Tuning [Tried & Tested] SQL Server Disk Configuration Best Practices
SQL Server Performance Tuning 54-Step SQL Server Setup Checklist
SQL Server Performance Tuning 7 Essential SQL Server DMV Queries Every Admin Should Know
SQL Server Performance Tuning How To Enable SQL Server Query Store [Best Practices]
SQL Server Performance Tuning Stored Procedures and RECOMPILE Option: When and Why to Use It
All Performance Tuning Tips & Resources
Index tuning and query optimization
Fixes you can run yourself. When the bottleneck goes deeper than a missing index, our SQL Server consulting team finds it with a free 145-point audit. Or have a senior DBA do it for you: see our SQL Server performance tuning services.
[7 Tips] How to Improve T-SQL Query Performance
7 T-SQL Development Tips For Faster Queries
Best Practices For SQL Server Statistics
Forcing Index, Order, And Join Hints And Being Careful
How We Cut SQL Server Costs in Half and Added HA for Free
Improve Your SQL Server Performance Enabling Data Compression
SQL JOINs Venn Diagram: A Visual Guide
SQL Query Optimization: A Practical Guide for Database Admins and Developers
SQL Server Index Tuning for Performance
What To Do When Your SQL Server Critical Report Starts Timing Out on Friday Evening
Monitoring, troubleshooting & analysis
7 Essential SQL Server DMV Queries Every Admin Should Know
How Can You Find The SQL Server Jobs That Start Simultaneously?
How To Enable SQL Server Query Store [Best Practices]
How To Troubleshoot A Slow-Running Query Using Wait Stats In SQL Server?
Monitoring Deadlocks In The SQL Server
SQL Server Monitoring & Alerts and Why Most Companies Are Doing It Wrong
SQL Server Performance Has Been Tuned, But What I Got Is “I Cant Feel It!” Wait! What??
The SQL Server Memory Setting That Might Be Killing Your Performance
Wasting CPU For Implicit Conversions In SQL Server
When Was The Last Time Your SQL Server Wait Stats Were Cleared?
Storage and hardware speed optimizations
[Tried & Tested] SQL Server Disk Configuration Best Practices
AWS Storage Types Comparison: A Complete Overview (S3, EBS, EFS)
Hardware And Performance Tuning In SQL Server
How Many CPUs Is Your SQL Server Able To Use?
How to Copy Large Volumes of Data from One Table to Another Database[Or 18Gb in 5min]
Improve Your SQL Server Transaction Log Performance Using Delayed Durability
Increasing Cost Threshold For Parallelism May Improve Your SQL Server Performance
Why Disk Operations Matter The Most When Tuning T-SQL Calls For Performance
You Scaled Your VM to 32 Cores. Your TempDB Configuration Didn’t
Advanced topics and best practices
[Full Guide] What Are SQL Server Heap Tables and How to Find Them
Best Practices For Performance Counters In Microsoft SQL Server
Database Engine Tuning Advisor (DTA) in Microsoft SQL Server
How SQL Tuning Saved Six Figures and Cut Cores by 75%
Page Life Expectancy & Why Should You Care?
SQL Server Parameter Sniffing: What It Is and How to Fix It
Stored Procedures and RECOMPILE Option: When and Why to Use It
Top 10 SQL Server Performance Tuning Mistakes
Untrusted Foreign Keys And Constraints Can Degrade Your SQL Server Performance
Why Picking the Right Data Types in SQL Server Matters
Performance tuning reports
Case Study: How Red9 Transformed SQL Server Performance and Saved 66+ Minutes of Daily Processing in 6 Weeks
How We Slashed SQL Query Disk Read Operations by 1,152 Times
How We Made T-SQL Queries Run 51 Times Faster
How We Made T-SQL Queries Run 11 Times Faster
How We Boosted SQL Performance by 40x
How We Made T-SQL Queries 4 Times Faster
How We Boosted SQL Server Performance to Run 51 Times Faster
How We Made T-SQL Queries 8 Times Faster
How We Made T-SQL Queries 3 Times Faster
How We Made SQL Server Run 9 Times Faster
How We Made T-SQL Queries 6 Times Faster
Discover More
Discover what clients are saying about Red9
Red9 has incredible expertise both in SQL migration and performance tuning.
The single biggest benefit has been performance gains and tuning associated with migrating to AWS and a newer version of SQL Server with Always On clustering. Red9 was an integral part of this process.… The deep level of knowledge of MSSQL is incredible and the combined experience and expertise has been a huge asset.… Red9 was able to find a number of inefficient indexes and performance bottlenecks that resulted in over 400% improvement in latency.
Rich StaatsCloud EngineerMetalToad