article thumbnail

AMD EPYC Processors in Azure Virtual Machines

SQL Performance

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. GHz Intel Xeon E5-2673 v3 (Haswell) processors that Microsoft uses for many of their Azure VM series. Azure Lsv2 Details. Table 1: Lsv2 Series Azure VM Specifications.

Azure 42
article thumbnail

Common SQL Server Mishaps

SQL Performance

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
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Stuff The Internet Says On Scalability For June 22nd, 2018

High Scalability

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. Eitally : there are a few critical differences between GCP and AWS or Azure.

Internet 113
article thumbnail

Introduction to Wait Statistics

SQL Performance

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. You can also get wait statistics using the Server Reports add-in to the new Azure Data Studio tool, and using Query Store from SQL Server 2017 onwards. If you’re reading this and thinking “what is he talking about?”

Servers 40