High Scalability

JUNE 27, 2019

Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019?

Open Source 196

Open Source Database Cloud Strategy 196

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. Ford, et al., “TCP

Performance 110

Performance Latency Cache Virtualization 110

SQL Performance

APRIL 26, 2019

Have you ever contacted Microsoft or a Microsoft partner and discussed with them what it would cost to move to the cloud? If so, you may have heard about the Azure SQL Database DTU calculator , and you may have also read about how it has been reverse engineered by Andy Mallon. Device] table, and pass that value.

Azure 40

Azure Database Metrics Servers 40

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. That's about 24 hours from now! Ford, et al., “TCP

Performance 52

Performance Latency Cache Virtualization 52

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. } ; We now have correct lengths for the column definitions, and we won't be passing them as LOBs over TDS to SQL Server.

Servers 55

Servers Azure Hardware Network 55