SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. One important choice you will still have to make is what type and size of Azure virtual machine you want to use for your existing SQL Server workload.

Azure 72

Azure Virtualization Servers Storage 72

SQL Server According to Bob

DECEMBER 18, 2018

Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. Neal, Matt, and others from Windows Storage, Windows Azure Storage, Windows Hyper-V, … validating Windows behaviors. · This flag does NOT imply flush behaviors, only the avoidance of the system file cache.

Servers 90

Servers Media Cache Storage 90

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. Azure SQL Database and Azure Managed Instance have managed backups. This issue is valid for on-premises, IaaS, and partially for Azure SQL Managed Instance. Statistics.

Servers 49

Servers Azure Hardware Database 49

The Morning Paper

FEBRUARY 20, 2020

" This is very important performance-wise: unlike most traditional ML frameworks, NN engines support out-of-the-box hardware acceleration through GPUs/FPGAs/NPUs as well as code generation." For single or very small numbers of predictions, Raven is faster due to SQL Server’s caching. " Query execution. The last word.

Processing 72

Processing Hardware Database Azure 72

The Morning Paper

SEPTEMBER 19, 2019

Microsoft have a paper describing their new recovery mechanism in Azure SQL Database , the key feature being that it can recovery in constant time. Could it be Analyzing efficient stream processing on modern hardware ? It handles an order of magnitude more throughput than a prototype built on a stream processing engine.

Blockchain 46

Blockchain Hardware Google Analytics 46

SQL Server According to Bob

AUGUST 23, 2021

The decision is performance driven. ​​ A memory node represents the memory associated with a group of CPUs from the physical hardware. For example: A smaller sized, SQL Azure database , ​​ using 2 CPUs , ​​ could be assigned to CPU 2 and 3 on the host machine.

Servers 40

Servers Azure Operating System Database 40

High Scalability

NOVEMBER 25, 2019

Edge caching. In general, Egnyte connect architecture shards and caches data at different levels based on: Amount of data. Nginx for disk based caching. Tens of petabytes of data stored in our servers and other object stores such as GCS, S3 and Azure Blobstore. Disk based caching. Hybrid Sync. Offline access.

Architecture 52

Architecture Cache Azure Storage 52