SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

SQL Server According to Bob

JUNE 3, 2016

My development collogues and I are starting a regular blog series, outlining the vast range of scalability improvements, allowing SQL Server 2016 to run across a wide array of hardware configurations, faster and better than previous releases of SQL Server. Try SQL Server 2016 Today.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

The Agile Manager

MAY 31, 2020

By way of example, nations have low tolerance to bank failures because the panic that results from them has knock-on effects in the financial and real economies alike (as exemplified by Lehman in September, 2008). From a certain point of view, a lot of banks were nationalized by governments in the wake of the 2008 financial crisis.

Airlines 52

Airlines Government Hardware Technology 52

Brendan Gregg

FEBRUARY 28, 2023

References I've reproduced the references from my SREcon22 keynote below, so you can click on links: [Gregg 08] Brendan Gregg, “ZFS L2ARC,” [link] , Jul 2008 [Gregg 10] Brendan Gregg, “Visualizations for Performance Analysis (and More),” [link] , 2010 [Greenberg 11] Marc Greenberg, “DDR4: Double the speed, double the latency?

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. Where this really can make a difference is in cloud implementations where you are paying for more than just compute and storage resources.

Servers 55

Servers Azure Hardware Network 55

All Things Distributed

MAY 8, 2012

Amazon RDS currently supports SQL Server 2008 R2 and plans to add support for SQL Server 2012 later this year. pricing starts at $0.035/hour and is inclusive of SQL Server software, hardware, and Amazon RDS management capabilities. Under the License Included service model, you do not need to purchase SQL Server software licenses.

Cloud 115

Cloud Development AWS Servers 115

SQL Performance

AUGUST 27, 2019

It will also use less power than a two-socket Intel server, with a lower hardware cost, and potentially lower licensing costs (for things like VMware). A one-socket AMD EPYC 7002 Series server can have up to 64 physical cores, 4TB of DDR4-3200 RAM, and 128 PCIe 4.0 AMD is not going to stand still and wait for Intel to catch up.

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

JUNE 21, 2019

While hardware such as intelligent SANs, Solid State Disk, and other advancements have helped speed things up, wasted space in index can translate to wasted space in the buffer pool as well as wasting more I/O. If you have big physical hardware with defaults, then you should look at optimizing MAXDOP.

Servers 49

Servers Azure Hardware Database 49

Randon ASCII

FEBRUARY 25, 2018

In this particular investigation, which spanned twenty months, we suspected hardware failure, compiler bugs, linker bugs, and other possibilities. Jumping too quickly to blaming hardware or build tools is a classic mistake, but in this case the mistake was that we weren’t thinking big enough.

Programming 79

Programming Hardware Cache Code 79

SQL Performance

MARCH 17, 2020

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. The serial aggregate push down result of 13ms is equally impressive.

Servers 86

Servers Tuning Database Efficiency 86

The Agile Manager

MARCH 18, 2013

Soon after the financial crisis began in 2008, companies shifted attention from finance to operations. A reduction in business investment is not particularly good news for tech firms selling hardware, software or services to companies. The crisis also ushered in a period of tepid growth undermined by persistent economic uncertainty.

Engineering 40

Engineering Innovation Government Hardware 40

All Things Distributed

APRIL 5, 2012

Jack: Since our launch in late 2008, weve grown to over 6 million teachers and students globally primarily through word of mouth of teachers who have shared Edmodo with each other. Moving to AWS has enabled us with operational agility to deliver more value to those customers without having to worry about scale and infrastructure maintenance.

Innovation 146

Innovation AWS Education Network 146

Tim Kadlec

JULY 31, 2013

When he first gave the presentation in 2008, he was working at this massive company called Yahoo! That was 2008. So many blog posts, online publications, and presentations continually challenged me to move forward by presenting new techniques and ways of thinking about the technology I used on a daily basis. Here at Yahoo!,

Google 40

Google Website Hardware Games 40

The Agile Manager

JANUARY 10, 2011

Tech, and especially tech services, went counter-cyclical a few months into the last recession (2008). There's been a sea-change in the technology sector, from counter-cyclical to pro-cyclical. Companies entered the downturn with record levels of cash. With so much uncertainty, most firms didn't bet on expansion.

Hardware 40

Hardware Internet Internet Mobile 40

Brendan Gregg

SEPTEMBER 5, 2017

Nowadays, there are three built-in tracers that you should know about: - **ftrace**: since 2008, this serves many tracing needs, and has been enhanced recently with hist triggers for custom histograms. It's fast, but limited in places, and usually only suited as a single-user tool (there are workarounds).

Virtualization 76

Virtualization AWS Engineering Hardware 76

O'Reilly

SEPTEMBER 19, 2023

” Consider the structural evolutions of that theme: Stage 1: Hadoop and Big Data By 2008, many companies found themselves at the intersection of “a steep increase in online activity” and “a sharp decline in costs for storage and computing.” Millions of tests, across as many parameters as will fit on the hardware.

Hardware 99

Hardware Storage Big Data Blockchain 99