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
[Case Study] Tuning SQL Performance and making TSQL run by 40 times faster! How did we do it?
Description: Problem: Slowness in the biling process. Solution: SQL code refactoring. Time to run stored proc before tuning: 34s Time to run stored proc after
[Case Study] We tuned SQL Server Performance and now its 103 TIMES faster(not a typo)! How did we do it?
Description: Problem: Slow procedure killing SQL Server performance Change: To improve the stored procedure performance, we created four views. Also, we made changes to the
[Case Study] We tuned SQL Server Performance and now its 679 TIMES faster(not a typo)! How did we do it?
Description: Problem: Slow stored procedure Notes: After making couple of small tweaks to the SQL Server stored procedure we were able to get few improvements:
[Case study] Tuning SQL Performance to run 753 times faster! How did we do it?
Problem: Slow stored procedure 75,336% improvement in stored procedure performance! Notes: Improvements achieved: • CPU from 18,922 to 1,249 • Reads from 12,850,589 to 18,532
The proper way to setup SQL Server alerts
Missing alerts Why should you enable SQL Server alerts? Enabling these Alerts can prevent a lot of problems: Potential to miss critical issues. Missing out
Why should you enable SQL Server database backup compression by default?
What is the SQL backup compression default option? This setting determines whether SQL Server will compress backups by default or not. Why does SQL backup
[Case Study] Tuning SQL Performance to run 66 times faster! How did we do it?
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] We tuned SQL Server Performance and now its 354 times faster(not a typo)! How did we do it?
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] We tuned SQL Server Performance and now TSQL is 562 times faster(not a typo)! How did we do it?
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
SQL Server Error logs not optimally What’s the SQL Server error log? It’s a file used by SQL server to write data about events that
Best practices for the SQL Server TempDB
SQL Server Error logs not optimally configured. What is the TempDB database? Tempdb is one of the system databases in Microsoft SQL Server. It’s a