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
How to eliminate SQL Server migrations performance risks with DReplay
Using THE least used SQL feature Distributed Replay (DReplay) There are a lot of things that can go wrong during SQL Server migration. One of
How to re-initialize SQL Server Merge replication publication
SQL Server Merge Steps 1. Connect to publisher instance: CIXSQL01\TOUCHSTORE. 2. Click right on Replication folder and click on “Launch Replication Monitor” option. 3. Click
Performance Tuning Report – 7,675x faster!
SQL Server Tuning Case Study This is the case when tuning sometimes can not be done perfectly. We are trying to change DB code, so
Why disk operations matter the MOST when tuning T-SQL calls for performance
“Disk” Explained “Disk” – has different names. I think that confuses anyone outside of DBA little world. Alternate names some DBAs call Disk (including myself)
Performance Tuning Report – 340% CPU gain
Server Tuning Report This tuning requires a bit of a different explanation. In some cases, client server is pressure on different resources. The three resources/parameters
Before vs. After Performance Tuning Report – 1,600% gain
Another tuning. Another significant gain. More details: Here is the Excel version. See more SQL Server Performance Optimization examples here. We tune slow SQL Servers
How to configure Antivirus running on SQL Server
There is a lot of AV products from different vendors like Avast, McAfee, Sophos, BitDefender, Kaspersky… First, I’d question having Antivirus on SQL Server if
12 SQL Server Monitoring Jobs
The best SQL monitoring practices (even if Santa brought you all third party software licenses you asked for) I don’t care how many third
Applying SQL Server & Window patches to AlwaysOn clusters
How to apply Windows or SQL Server patches to failover MS SQL Server cluster with AlwaysOn – Step by step SQL cluster patching best practices
Performance Tuning Report – 9320x faster!
Total improvement: 932,058% Not bad, huh? These type of database speed improvements makes me smile! 🙂 Here is another SQL Server performance tuning report. Before
SQL Performance Tuning Report – 7,039% improvement
Speed improved by: 4,780% + 565% + 1,763% or 7,108% total improvement. Not bad for the results that we got before I ate my cereal
How to migrate SQL Server to Azure SQL database
Azure SQL Database is a fully managed service. With this platform as a service (PaSS) option, organizations can reduce management overhead and quickly deliver highly