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 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

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 116

Cloud Development AWS Servers 116

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 149

Innovation AWS Education Network 149

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 76

Virtualization AWS Engineering Hardware 76

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

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