SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

Dynatrace

MAY 31, 2021

Since Kubernetes emerged in 2014, it has become a popular solution for scaling, managing, and automating the deployments of containerized applications in distributed environments. At its start in 2013, Docker was mainly used by developers as a sandbox for testing purposes. What are containers, and why are they so hot?

Virtualization 133

Virtualization DevOps Infrastructure Cloud 133

SQL Performance

JULY 27, 2021

Continuing my series of articles on latches, this time I’m going to discuss the DBCC_OBJECT_METADATA latch and show how it can be a major bottleneck for consistency checks prior to SQL Server 2016 under certain circumstances. But remember, this bottleneck only happens for versions of SQL Server earlier than SQL Server 2016.

C++ 54

C++ Servers Database Code 54

SQL Performance

MAY 16, 2019

Without this guarantee, SQL Server might add index rows that are not sorted correctly, which would not be good. For INSERT.SELECT , SQL Server makes its own determination whether to ensure rows are presented to the Clustered Index Insert operator in key order or not. Test ; END ; GO. DMLRequestSort Conditions. DROP TABLE dbo.

Cache 67

Cache Servers Testing Storage 67

The Netflix TechBlog

APRIL 17, 2019

Netflix headquarters circa 2014. SVT-AV1 uses parallelization at several stages of the encoding process, which allows it to adapt to the number of available cores including newest servers with significant core count. The open-source encoder should also enable easy experimentation and a platform for testing new coding tools.

Open Source 166

Open Source Scalability Speed Efficiency 166

SQL Performance

MAY 1, 2019

The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking. The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model.

Servers 47

Servers Database Testing Performance 47

MachMetrics

JUNE 16, 2020

Google made SSL use a ranking factor way back in 2014, and since Chrome 68, a “Not Secure” warning appears next to the URL of sites that aren’t using HTTPS. These are typically implemented automatically by the hosting company servers. The server can also preemptively send resources, reducing delays.

Speed 86

Speed Latency Google Website 86

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. Test Environment. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. The cost threshold for parallelism is set to 50.

Servers 86

Servers Tuning Database Efficiency 86

All Things Distributed

OCTOBER 25, 2018

Hyrax has developed an AWS based technology called Exatype, which rapidly and accurately tests HIV drug resistance. Traditionally, it cost $300 to $500 to do a single resistance test. Since it launched in 2014, more than 9 million people have saved or borrowed on the JUMO platform.

AWS 167

AWS Cloud Education Programming 167

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link]. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Brendan Gregg

NOVEMBER 29, 2017

It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. When I joined Netflix in 2014, we had begun transitioning from PV to HVM (PVHVM). My colleague Amer Ather was responsible for testing it and making it work at Netflix, and posted some of his results: [2 Million Packets Per Second on a Public Cloud Instance].

Virtualization 111

Virtualization AWS Hardware Storage 111

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. The following chart shows the same 1TB database testing. SQL Server. SQL Server 2014.

Hardware 40

Hardware Cache Servers Software Engineering 40

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. This server is spending about a third of its CPU cycles just checking the time! This will slow this test a little.)

Speed 40

Speed Java AWS Virtualization 40

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. This server is spending about a third of its CPU cycles just checking the time! This will slow this test a little.)

Speed 52

Speed Java AWS Virtualization 52

SQL Performance

APRIL 23, 2019

In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate. SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. Introduction. instructions are available.

Servers 67

Servers Testing Metrics Storage 67

Tim Kadlec

SEPTEMBER 25, 2014

For this test, I decided to profile just jQuery 2.1.1, The results above are based on the median times taken from 20 tests per browser/device combination. The results above are based on the median times taken from 20 tests per browser/device combination. Macbook Air (2014). Macbook Air (2014). Macbook Air (2014).

Latency 41

Latency Google Hardware Servers 41

Abhishek Tiwari

NOVEMBER 3, 2018

If you put your whole website on CDN, technically you don’t need a large number of server infrastructure and CMS licenses. They often get blindsided by vendor’s pitch and end-up making decision based on some fancy demos (see my post from 2014 on Adobe AEM ). Circa 2014, I was working with a big Japanese automotive brand in Australia.

Systems 63

Systems Cache Website Network 63

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented.

Servers 95

Servers Tuning Architecture Processing 95

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016.

Cache 64

Cache Testing Servers Code 64

Sutter's Mill

MARCH 11, 2024

Rules like those summarized in the Appendix would have prevented (at compile time, test time or run time) most of the past CVEs I’ve reviewed in the type, bounds, and initialization categories, and would have prevented many of the lifetime CVEs. Kubernetes Secrets on public GitHub repos), misconfigured servers (e.g.,

C++ 139

C++ Programming Code Java 139

Enprowess

SEPTEMBER 28, 2021

Inferno JS would be your best option, if you would like to build client and server-side interfaces with faster speeds, better performance, and isomorphic rendering. . You will get add-ons like server-side rendering, routing and more. The DOM structure is surrounded by Inferno for browser/server edits. Inferno Pros. Backbone JS.

Open Source 52

Open Source Mobile Entertainment Virtualization 52

Enprowess

SEPTEMBER 20, 2021

Created by Evan You, Vue had its first public appearance in 2014. You’ll be able to use a scaffolding tool referred to as create-react-app to begin building your project , establish a local development server, check your code for errors, and execute unit tests/e2e. Server-Side Rendering. to render pages on the server.

Open Source 52

Open Source Mobile Scalability Google 52

Brendan Gregg

NOVEMBER 28, 2017

It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. When I joined Netflix in 2014, we had begun transitioning from PV to HVM (PVHVM). My colleague Amer Ather was responsible for testing it and making it work at Netflix, and posted some of his results: [2 Million Packets Per Second on a Public Cloud Instance].

Virtualization 40

Virtualization AWS Hardware Storage 40

Alex Russell

MARCH 6, 2021

Devices and networks have evolved too: Alex Russell @slightlylate An update on mobile CPUs and the Performance Inequality Gap: Mid-tier Android devices (~$300) now get the single-core performance of a 2014 iPhone and the multi-core perf of a 2015 iPhone. mid-priced Androids were slightly faster than 2014's iPhone 6.

Performance 124

Performance Network Cache Metrics 124

KeyCDN

JUNE 20, 2019

With a CDN, you can offload your static assets such as product images, videos, GIFs, CSS files, and much more to the CDN’s edge servers. Then, when someone makes a request for one of your store’s webpages they will be delivered content from the CDN’s nearest edge server instead of your origin server.

Ecommerce 41

Ecommerce Speed Website Mobile 41

Enprowess

JANUARY 11, 2022

This prevents bad practices like code duplication and simplifies unit testing by many miles. Server side rendering is a massive boost for Search Engine Optimization (SEO). Easy to perform Ajax requests with a dedicated server. Material UI was introduced in 2014 with a goal to bring Android’s material UI to the web with React.

Virtualization 64

Virtualization Website Speed Mobile 64

Scalegrid

AUGUST 15, 2019

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. Should have an excellent way to measure server and query performance. Import data from RDBMS like MySQL, PostgreSQL, and SQL Server.

Database 40

Database Servers Monitoring Availability 40

Brendan Gregg

SEPTEMBER 5, 2017

We're now testing container hosts in production on btrfs, instead of ZFS. Oracle VM Server is based on Xen. I came up with a great demo where I could break Solaris 9 and 10 servers in the same way, then demonstrate how it would take an hour and a reboot cycle to fix Solaris 9, but minutes and no reboot to fix Solaris 10.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Rigor

SEPTEMBER 11, 2019

Patrick is a London-based software developer who specializes in web performance and who describes himself as enjoying “working the entire stack, back-end to front-end, CDN to server.” The future of HTTP/2 server push. You can find him on Twitter @ patrickhamann or catch him on the speaker circuit. Billy Hoffman.

Performance 89

Performance Education Google Website 89

SQL Server According to Bob

DECEMBER 31, 2018

How It Works: XEvent Output and Visualization SQL Server Management Studio Provides–“XE Profiler” Use the SSMS XEvent Profiler. Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. TSQL Sample Session.

Efficiency 40

Efficiency Code Servers Cache 40

O'Reilly

JULY 25, 2023

To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022. This choice also inspired me to call my project Swift Papers.

Programming 98

Programming Code Design Benchmarking 98