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
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:
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
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
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
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
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
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
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