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 – Disk performance 10x slower than expected!
Several different methods can be used to track I/O performance to determine if there is an I/O bottleneck. Tools are available at both the storage level
[Case Study] We tuned SQL Server Performance and now its 1,266% faster(not a typo)! How did we do it?
Real sample The procedure below was extracted from a stored procedure that was found during a database Assessment. It was causing CPU pressure on the client’s
Automate your SQL Server tasks using DBATools (PowerShell)
What is dbatools? Dbatools is an open-source module of PowerShell developed by big names from the SQL server community, MVPs, and other SQL server and
How to test SQL migrations using log shipping
What is the t key to SQL Upgrades project success? Preparation. Prep work is going to take 80-90% of the time. SQL Server install and
Microsoft SQL Server Builds
SQL Server is Microsoft’s main data platform. It is one of the best operational database management system (ODBMS). This article lists all the official builds
How to encrypt drives on live SQL Server with AlwaysOn
To encrypt drives for AlwaysOn, I would suggest these steps: – Do encryption during low usage hours. – encrypt drives on SECONDARY first. Without taking
[Case Study] Detecting and Resolving SQL Deadlocks and fixing SQL Server Performance. How did we do it?
Problem Summary Deadlocks are a common problem handled by SQL Server automatically. Nevertheless, you have to make sure that you minimize deadlocks as much as
SQL Performance is faster by 915 times! How did we do it?
Real sample The query plan below was extracted from a stored procedure that was found during database Assessments. It was causing a high number of
[Case Study] We Tuned SQL Server Performance and now TSQL runs 24,000 TIMES faster(not a typo)! How did we do it?
Real sample Here what can be done during a session of SQL performance tuning. This query was running for a long time, causing a blocking
Case study – Slow storage affecting SQL Server performance
Problem Summary: Queries take a longer time than usual in processing. Suddenly, the queries that were fast before became slower. There are many reasons why
[Case Study] SQL Server Performance Problem with CPU at 100% Usage
Problem Summary: The client was experiencing severe SQL Server performance issues; Multiple queries were taking 1, 5, 10 minutes or longer or timing out; The
[Case study] High Availability (HA) and Disaster Recovery (DR)
Problem Summary: Finding the right high availability option can be difficult. Which choice is right for you can depend on the following: Budget – first