SQL Server According to Bob

JUNE 9, 2016

SQL Server, as outlined in the following post ( [link] ) adjusts to various processor configurations. I have received questions related to how SQL Server accomplishes the alignment on both bare metal and VM installations. SQL Server uses Windows APIs to determine the processors and package interactions. GetSystemInfo [link].

Servers 40

Servers Virtualization Tuning Architecture 40

KeyCDN

JANUARY 31, 2019

With Bucharest being the capital and largest city of Romania, it makes for a great edge server location. However, now with the Bucharest edge server in production, it helps further close the gap between visitors who live in Romania and the nearest KeyCDN POP they have access to. As of 2016, Bucharest alone had a population of over 1.83

Internet 48

Internet Internet Ecommerce Speed 48

Alex Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. I decided to publish a few parts here to see if anything triggers a discussion. It would be published as separate posts: – Introduction (a short teaser).

Performance Testing 100

Performance Testing Architecture Testing Performance 100

KeyCDN

OCTOBER 24, 2018

With Helsinki being the capital and most populous municipality of Finland, it makes for a great edge server location. However, now with the Helsinki edge server in production, this helps further close the gap between visitors who live in Finland and the nearest KeyCDN POP they have access to. As of 2016, there were just over 5.1

Internet 48

Internet Internet Speed Network 48

Brendan Gregg

OCTOBER 8, 2018

bpftrace has most of DTrace's capabilities and more. ## bpftrace The prior work that led to [bpftrace] (aka BPFtrace) is discussed my earlier [DTrace for Linux 2016] post, which explains how the Linux kernel gained [eBPF]: the virtual machine that we're using to run tracing programs. bcc is powerful but laborious to program.

C++ 110

C++ Virtualization Programming Latency 110

SQL Performance

DECEMBER 9, 2020

I tested my solutions in SQL Server 2019 Enterprise edition. SQL Server chose row mode processing for all previously shown solutions by default. There are a couple of ways to get SQL Server to use batch processing here. So, my tuning efforts ended up yielding an improvement of 43.5 For these reasons, I prefer option 1.

C++ 114

C++ Servers Testing Processing 114

Percona

JANUARY 17, 2019

I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, 84.1 | | version_comment | Percona Server (GPL), Release 84.1, AWS Aurora (based on MySQL 5.6) MySQL on ec2. MySQL on ec2.

Cache 46

Cache C++ AWS Airlines 46

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. I wrote a page on it: [perf]. - **eBPF**: tracing features completed in 2016, this provides efficient programmatic tracing to existing kernel frameworks. Oracle VM Server is based on Xen. The hardest part on Linux is now done: kernel support.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Rigor

JANUARY 13, 2020

These are the bestsellers in the web performance field, including the good old Speed Up Your Site (2003) by Andy King; Steve Souders’ Even Faster Web Sites (2009) ; Ilya Grigorik’s High Performance Browser Networking (2013) ; Tammy Everts’ Time is Money (2016) ; and a handful of more recent publications. Responsive and Fast.

Performance 75

Performance Social Media Website Website Performance 75

SQL Performance

DECEMBER 9, 2020

I tested my solutions in SQL Server 2019 Enterprise edition. SQL Server chose row mode processing for all previously shown solutions by default. There are a couple of ways to get SQL Server to use batch processing here. So, my tuning efforts ended up yielding an improvement of 43.5 For these reasons, I prefer option 1.

C++ 61

C++ Servers Testing Processing 61

SQL Performance

SEPTEMBER 2, 2021

SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT().

C++ 59

C++ Servers Testing Database 59

SQL Performance

MAY 7, 2019

I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server. The execution of SQL Server’s internal code is done using a mechanism called threads. When that happens, SQL Server makes a note of why the thread had to wait and this is called the wait type.

Servers 40

Servers Azure Metrics Tuning 40

SQL Performance

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). ORDER BY ExecutionCount DESC ; Note: The sys.dm_exec_function_stats DMV was added in SQL Server 2016. Each option has pros and cons. query_hash AS [ query_hash ] , qs.

C++ 74

C++ Database Servers Tuning 74

Brendan Gregg

OCTOBER 7, 2018

bpftrace has most of DTrace's capabilities and more. ## bpftrace The prior work that led to [bpftrace] (aka BPFtrace) is discussed my earlier [DTrace for Linux 2016] post, which explains how the Linux kernel gained [eBPF]: the virtual machine that we're using to run tracing programs. bcc is powerful but laborious to program.

C++ 40

C++ Virtualization Programming Latency 40

Rigor

SEPTEMBER 11, 2019

Follow him on Twitter @ RickByers and be sure to watch the video of his conversation at Chrome Dev Summit 2016 , where he discussed the ways Chrome is “improving predictability for developers.” The future of HTTP/2 server push. ” Paul Calvano. Paul Calvano. Billy Hoffman. Billy Hoffman. Doug Sillars. Doug Sillars.

Performance 89

Performance Education Google Website 89

Rigor

SEPTEMBER 3, 2019

What you may be overlooking is that peak-event readiness is about more than just load testing or ensuring that your servers are up throughout a specific timeframe. Servers down or server health issues [APM]. STEP 7: Tune Your CDN Performance. Traffic patterns outside of normal [RUM or Analytics].

Website 74

Website Cache Ecommerce Traffic 74

Alex Russell

MARCH 31, 2022

Like every other successful platform, the web operates on a finely tuned understanding of risk and trust , and deprecations are particularly explosive. [2] Late in the drafting of this post, it was pointed out to me by Frederik Braun that Brad Hill had considered the downsides of a site-populated SRI addressable cache back in 2016.

Cache 82

Cache Government Traffic Network 82

Percona

JANUARY 14, 2019

['scala','currency','println'] ? ? voting','maven'] ? ? compose','xamarin','markdown','scrum','comic'] ? ? china','sourceforge','subscription','chinese','kotlin'] ? ? systemd','gitlab','autotldr'] ? ? refugees','refugee','sanders','debates','hillary','removal','participating','removed','greece','clinton'] ? ?

Database 40

Database Analytics Blockchain Healthcare 40