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
Improve your SQL Server performance enabling data compression
What is the data compression feature in SQL Server? It is a feature introduced in SQL Server 2008 Enterprise Edition. Later, Microsoft added to Standard
How to check for updates in SQL Server Management Studio (SSMS)?
Category: reliability Item: SSMS missing updates Microsoft has made SQL Server Management Studio (SSMS) a product on its own and is providing updates directly for
Should you use the SQL Server change tracking feature?
What is the SQL Server change trackings feature? Change tracking was introduced in SQL Server 2008 to help you sync data. It allows relatively easy
Indexes can hamper the SQL Server performance too
You’ve probably heard: “indexes are not free”. They are right! Indexes can greatly improve queries performance in the SQL server, but they may hamper the
Best practices to enable SQL Server Query Store for a database
What is the Query Store? The SQL Server Query Store is a feature introduced in SQL Server 2016. It provides you with insight on query plan choice
Case study – 2307x faster!
Description: Problem: Stored procedure takes 38 seconds to execute. It times out on the application front-end. It was performing multiple scans and reading too much
Case study – 57x faster!
Description: Problem: This stored procedure showed up in the top resource-consuming report. It was putting too much stress on the CPU. Solution: Added two new
Case study – 9,320x faster!
Description: Problem: Select command inside trigger (EHRHist<removed>_AFTER_INSERT_UPDATE) doing an index scan. Solution: Added an index. Command: Change: Before: After: Technical Background: Most SQL Servers bottleneck
Case study – 40x faster!
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 – 103x faster!
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 – 679x faster!
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 – 753x faster!
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