SQL Performance

APRIL 8, 2019

These VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. The AMD EPYC 7551 processor has slightly lower single-threaded CPU performance when compared to the older 2.3 Azure Lsv2 Details. Table 1: Lsv2 Series Azure VM Specifications.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

High Scalability

JUNE 22, 2018

Each drone is rated with a game mechanic and gets special privileges based on performance (just kidding). using them to respond to storage events on s3 or database events or auth events is super easy and powerful. Ultimately, Netflix did end up paying Comcast in 2014 and, surprise surprise, the throttling stopped.

Internet 113

Internet Internet Scalability Artificial Intelligence 113

SQL Performance

MAY 7, 2019

Back in 2014, I started a series of blog posts here to talk about specific wait types and what they do and don’t mean. I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server. If you’re reading this and thinking “what is he talking about?” Scheduling.

Servers 40

Servers Azure Metrics Tuning 40