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
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
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
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
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
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
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
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
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
Problem Summary: Finding the right high availability option can be difficult. Which choice is right for you can depend on the following: Budget – first