SQL Server According to Bob

JUNE 6, 2016

SQL Server asks the CPU if it supports SSE or AVX in order to determine the level of hardware support present on the system. Windows 2012 R2 and newer releases have been enlightened the Crypto* APIs. Version of SQL Server 2012, 2014, and 2016 using the Crypto* APIs take advantage of the hardware implementations through the API support.

Servers 40

Servers Hardware Software Engineering Software 40

Brendan Gregg

FEBRUARY 28, 2023

Make sure your system can handle next-generation DRAM,” [link] Nov 2011 - [Hruska 12] Joel Hruska, “The future of CPU scaling: Exploring options on the cutting edge,” [link] Feb 2012 - [Gregg 13] Brendan Gregg, “Blazing Performance with Flame Graphs,” [link] 2013 - [Shimpi 13] Anand Lal Shimpi, “Seagate to Ship 5TB HDD in 2014 using Shingled Magnetic (..)

Performance 110

Performance Latency Cache Virtualization 110

All Things Distributed

JULY 20, 2012

By Werner Vogels on 20 July 2012 12:00 PM. Stanfords Disco, the predecessor of VMWare, uses a full hardware virtualization approach, where Cambridges Xen introduced us to paravirtualization. Comments (). This weekends back-to-basics reading is on operating system virtualization.

Operating System 97

Operating System Virtualization Systems Hardware 97

Sutter's Mill

NOVEMBER 30, 2012

I said something similar to the above, but with two important differences: I said hardware “threads,” not only hardware “cores” – it was about the amount of hardware parallelism available on a mainstream system. Figure 4 : How much concurrency does your program need in order to exploit given hardware?

Hardware 40

Hardware Programming Scalability Software 40

All Things Distributed

AUGUST 24, 2012

By Werner Vogels on 24 August 2012 04:00 PM. In 1997 Jim revisted his caculations with the help of Goetz Graefe , and it details the impact of 10 years of hardware and pricing progress. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems. Back-to-Basics Weekend Reading - The 5 Minute Rule.

Storage 110

Storage Hardware AWS Data Engineering 110

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

All Things Distributed

MAY 8, 2012

By Werner Vogels on 08 May 2012 02:00 PM. 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. Comments (). License Includedâ??

Cloud 116

Cloud Development AWS Servers 116

Alex Russell

MARCH 6, 2021

The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively. Hardware Past As Performance Prologue. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version. Mind The Gap. Tap for a larger version.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

JUNE 21, 2019

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. If you have big physical hardware with defaults, then you should look at optimizing MAXDOP.

Servers 49

Servers Azure Hardware Database 49

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance. I'd expect between 0.1%

Virtualization 40

Virtualization AWS Hardware Storage 40

All Things Distributed

JANUARY 23, 2012

By Werner Vogels on 23 January 2012 12:01 AM. Data written to these volumes is maintained on your on-premises storage hardware while being asynchronously backed up to AWS, where it is stored in Amazon S3 in the form of Amazon EBS snapshots. All Things Distributed. Expanding the Cloud - The AWS Storage Gateway. Comments ().

Storage 116

Storage AWS Virtualization Cloud 116

All Things Distributed

AUGUST 16, 2012

By Werner Vogels on 16 August 2012 10:00 AM. An apples to apples comparison of the costs associated with running various usage patterns on-premises and with AWS requires more than a simple comparison of hardware expense versus always-on utility pricing for compute and storage. All Things Distributed. Comments ().

AWS 118

AWS Hardware Traffic Best Practices 118

Tim Kadlec

JANUARY 9, 2019

Hardware gets better, sure. In a 2012 paper, The American Council for an Energy-Efficient Economy estimated the internet uses 5 kWh on average to support every GB of data. Let’s say that you’re one of those people with a device a year or two old. It makes sense. Again, this isn’t hyperbole.

Performance 111

Performance Energy Internet Internet 111

Speed Curve

MARCH 7, 2022

The median page today serves 25 images, compared to 42 images back in 2012. Don't assume hardware and networks will mitigate page bloat. Image requests are way down, while image size is way up. We're serving fewer images, but the images we are serving are high-resolution and/or unoptimized. This trend carries over to mobile.

Mobile 145

Mobile Benchmarking Google Metrics 145

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

Brendan Gregg

FEBRUARY 28, 2023

Make sure your system can handle next-generation DRAM,” [link] , Nov 2011 [Hruska 12] Joel Hruska, “The future of CPU scaling: Exploring options on the cutting edge,” [link] , Feb 2012 [Gregg 13] Brendan Gregg, “Blazing Performance with Flame Graphs,” [link] , 2013 [Shimpi 13] Anand Lal Shimpi, “Seagate to Ship 5TB HDD in 2014 using Shingled Magnetic (..)

Performance 52

Performance Latency Cache Virtualization 52

All Things Distributed

SEPTEMBER 6, 2013

In 2012 Tom Tom launched a new Location Based Services (LBS) platform to give app developers easy access to its mapping content to be able to incorporate rich location based data into their applications. Tom Tom – Founded in 1991, TomTom is a leading provider of navigation and location-based products and services.

Cloud 130

Cloud Energy AWS Healthcare 130

High Scalability

JANUARY 4, 2019

By replacing branch-heavy algorithms with neural networks, the DBMS can profit from these hardware trends.". Explain the Cloud Like I'm 10 (34 almost 5 star reviews). copyconstruct : "GPUs will increase 1000× in performance by 2025, whereas Moore’s law for CPUs essentially is dead.

Internet 29

Internet Internet Scalability Healthcare 29

Sutter's Mill

DECEMBER 29, 2011

Now welcome to the hardware jungle. 2012 will see us continue to build out multicore with mainstream quad- and eight-core tablets (as Windows 8 brings a modern tablet experience to x86 as well as ARM), and the last single-core gaming console holdout will go multicore (as Nintendo’s Wii U replaces Wii). The free lunch is over.

Hardware 40

Hardware Games Operating System Software 40

SQL Server According to Bob

JUNE 3, 2016

Use SQL Server Management Studio (SSMS) or your favorite query editor to connect to a SQL Server 2012 or 2014 instance. On the same hardware/machine repeat steps 1 thru 3 using an instance of SQL Server 2016 CTP 3.0 Paste the script below in a new query window. Execute (ATL+X) the script and take note of the elapsed execution time.

Hardware 40

Hardware Cache Servers Software Engineering 40

Smashing Magazine

FEBRUARY 5, 2019

Although modern iOS hardware is powerful enough to handle many intensive and complex tasks, the device could still feel unresponsive if you are not careful about how your app performs. I recommend watching Apple’s WWDC 2012 video on UI concurrency to better understand how to build a responsive app. 2019-02-05T13:00:00+01:00.

Performance 75

Performance Energy Operating System Code 75

Alex Russell

FEBRUARY 21, 2023

In leaner years (2012-2015), a single Fall release was all we'd get. From outright misstatements about a competitor's security, to claims that performance differences in hardware show Safari is faster, to [geographic brinksmanship](/2022/02/minimum-standards/), the confident bluster hasn't gone down particularly well.

Energy 79

Energy Games Engineering Design 79

All Things Distributed

APRIL 5, 2012

By Werner Vogels on 06 April 2012 06:00 AM. However, the shining moment occurred just last month – during peak load there was a hardware failure on the Server powering a RDS Master Database – RDS automatically failed over to the alternate zone within minutes and our customers experience was fully functional shortly thereafter.

Innovation 149

Innovation AWS Education Network 149

SQL Server According to Bob

NOVEMBER 29, 2016

Automatic soft-NUMA was enabled because SQL Server has detected hardware NUMA nodes with greater than 8 physical cores. Let’s use an example with Microsoft Hyper-V on Windows Server 2012 R2 to see what this can look like. Windows Server 2012 R2 supports a max of 64 vCPUs per VM. And the node mapping has apparently gone crazy.

Servers 45

Servers Virtualization Scalability Hardware 45

The Agile Manager

JULY 31, 2012

The person hiding risk has a large informational advantage over the one looking for it. -- Nassim Taleb and George Martin, How to Prevent Other Financial Crises , SAIS Review, Winter-Spring 2012 The interests of buyer and builder of any asset are fundamentally divergent.

Hardware 45

Hardware Software Software Development 45

Alex Russell

JULY 14, 2021

Hardware access APIs, notably: Geolocation. From at least 2012, Apple has deigned to allow "competing browsers" in its App Store. In particular, folks will undoubtedly note that "alternative browsers" were available in the App Store much earlier, including a Chrome-branded app since at least 2012. Web Bluetooth.

Google 121

Google Mobile Engineering Internet 121

O'Reilly

SEPTEMBER 19, 2023

Doubly so as hardware improved, eating away at the lower end of Hadoop-worthy work. ” There’s as much Keras, TensorFlow, and Torch today as there was Hadoop back in 2010-2012. Google goes a step further in offering compute instances with its specialized TPU hardware. Those algorithms packaged with scikit-learn?

Hardware 98

Hardware Storage Big Data Blockchain 98

All Things Distributed

JUNE 21, 2012

By Werner Vogels on 21 June 2012 09:00 AM. ve already passed our 2012 targets. We switched to storing our game data in DynamoDB, which alleviated our scaling problems while also freeing us from the burden of managing all the underlying hardware and software. All Things Distributed. Comments (). In short, DynamoDB is taking off.

Games 142

Games Scalability AWS Database 142

All Things Distributed

OCTOBER 8, 2014

In 2012, we launched Amazon DynamoDB, the successor to Amazon Dynamo. We built DynamoDB as a fully-managed service because we wanted to enable our customers, both internal and external, to focus on their application rather than being distracted by undifferentiated heavy lifting like dealing with hardware and software maintenance.

Availability 145

Availability Performance Scalability AWS 145

All Things Distributed

JANUARY 18, 2012

By Werner Vogels on 18 January 2012 07:00 AM. DynamoDB frees developers from the headaches of provisioning hardware and software, setting up and configuring a distributed database cluster, and managing ongoing cluster operations. Werner Vogels weblog on building scalable and robust distributed systems. Amazon DynamoDB â?? Comments ().

Scalability 167

Scalability Database Ecommerce Latency 167