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. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Azure Lsv2 Details. AMD EPYC 7551 Details. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. 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. SQL Server Agent alerts. Database corruption happens unfortunately.

Servers 49

Servers Azure Hardware Database 49

High Scalability

JUNE 22, 2018

Charlie Demerjian : what does Intel have planned for their server roadmap? For the same reason the 14/10nm messaging is causing consternation among investors, but the server side is in much worse shape. using them to respond to storage events on s3 or database events or auth events is super easy and powerful. How bad is it?

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. SQL Server also keeps track of how long the thread has to wait. Scheduling.

Servers 40

Servers Azure Metrics Tuning 40