Before vs. After Perf Tuning Report #8 Speed improved by: 4,763% + 550% + 1,726% or 7,039% total improvement. Not bad for results that we got before I ate my serial in the morning. Here is another SQL Server performance tuning report. Before vs. After. “Before” – shows numbers before we made any changes.
How to Migrate On-Premise SQL Servers to Azure SQL Database Azure SQL Database is a fully managed service that allow you to focus on rapid app development and accelerate your time to market, rather than allocating precious time and resources to managing virtual machines and infrastructure. Azure delivers predictable performance at multiple service levels that
Microsoft SQL Server Migration Strategies to Amazon AWS Let’s assume that you have a SQL Server workload on Premises and want to take those to the cloud. You have two options for SQL Server for migrating to Amazon AWS. The first option is a self-managed option which would be installing SQL Server on EC2
Migrating Microsoft SQL Server to Amazon AWS RDS RDS is a managed database service that will do all the heavy lifting that you normally must do if you’re managing instances and databases yourself on on-premises SQL Server. It automates common database administration tasks like: Backup and restore Scaling Patching Upgrading the server High availability Failover
SQL Server Replication Performance Tuning What can be done when SQL Server Replication is slow. A lot of SQL Server Replication users think, SQL Replication that gets created with SQL Wizard – is all you can do. But there is a ton of knobs you can turn. How do I know there is MANY people
SQL Server MASSIVE Index Tuning Example Speed improved by 41,925% We often do massive SQL index tuning change. It usually happens, when server hasn’t had tender care for a while. And its ripe for a ton of SQL indexes changes. What index changes do we make: 1. adding missing indexes. 2. dropping unused indexes. 3.
6 ways to encrypt data inside SQL Server [in 2019] We recently got a question from someone about how to encrypt large SQL Server database for compliance reasons with minimal impact on software applications. There are number of ways to approach SQL Server data encryption. For compliance or whatever the purpose. Conclusion: using combination of
Before vs. After Perf Tuning Report #5 – 938,757% improvement Report Report #5… and a new tuning record! We do a lot of performance tuning of slow SQL Server code. In this example I will show you how we set our personal best record so far! 938,757% improvement in stored procedure performance! Improvements achieved: CPU
Before vs. After Perf Tuning Report #4 – 115,000% improvement In this tuning, the only thing that was tuned was disk operations. And here is what was done to get this improvement:
Before vs. After Perf Tuning Report #3 – 877% improvement Real example #3 Some SQL Server Consulting clients chose to tune databases periodically. This is one of those clients. Here is a recent example of performance tuning slow MS SQL Server Stored Procedure. And here is a capture from SQL Server Profiler to compare BEFORE
Before vs. After Perf Tuning Report #2 – 67,871% improvement Real example #2 Today I am sharing another MS SQL Performance tuning report from recent tuning. After making couple of small tweaks to the SQL Server stored procedure we were able to get few improvement: Run time duration improved by: 10,788% CPU improved by: 10,903% Disk
Before vs. After Perf Tuning Report #1 – 846% improvement Real Example #1 Some customers care about SQL Performance Tuning so much, that they use our database administrators for continuous Microsoft SQL Server performance tuning. Once we tune, I noticed sometimes it was hard to communicate benefit achieved. We struggled a bit with reporting which