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). This system has one AMD EPYC 7502P 32-core processor and 512GB of RAM. The price per QphH for this system is 0.34 The price per QphH for this system is 0.47

Servers 52

Servers Benchmarking Virtualization Architecture 52

Brendan Gregg

FEBRUARY 28, 2023

This talk originated from my updates to Systems Performance 2nd Edition , and this was the first time I've given this talk in person! CXL in a way allows a custom memory controller to be added to a system, to increase memory capacity, bandwidth, and overall performance. 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. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

All Things Distributed

MAY 8, 2012

Werner Vogels weblog on building scalable and robust distributed systems. 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. All Things Distributed.

Cloud 106

Cloud Development AWS Servers 106

SQL Performance

JUNE 21, 2019

I always check backups first when looking at a new system. Prior to SQL Server 2012, the maximum server memory value only applied to the bufferpool, so customers needed to limit the amount of memory the bufferpool could use to save memory for the operating system and other processes. Memory settings. Statistics. Index maintenance.

Servers 49

Servers Azure Hardware Database 49

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. This runs in 115ms using the same amount of CPU time. Final Thoughts.

Servers 86

Servers Tuning Database Efficiency 86

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

All Things Distributed

APRIL 5, 2012

Werner Vogels weblog on building scalable and robust distributed systems. 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. All Things Distributed. By Werner Vogels on 06 April 2012 06:00 AM. Comments ().

Innovation 129

Innovation AWS Education Network 129

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 75

Virtualization AWS Engineering Hardware 75

The Agile Manager

JANUARY 10, 2011

Tech, and especially tech services, went counter-cyclical a few months into the last recession (2008). That capital, while being deployed now, is still jittery and remains at risk of systemic shock. There's been a sea-change in the technology sector, from counter-cyclical to pro-cyclical.

Hardware 40

Hardware Internet Internet Mobile 40

Tech News Gather

NOVEMBER 5, 2023

Basics of Bitcoin and the Blockchain Technology Historical Evolution and the Rise of Bitcoin: Bitcoin, introduced in 2008 by the pseudonymous Satoshi Nakamoto, revolutionized the world of finance. However, the actual energy consumption varies based on the mining hardware and energy sources used.

Government 52

Government Blockchain Energy Innovation 52