SQL Server According to Bob

FEBRUARY 10, 2019

. · Failures occur from remote clients or sqlcmd executed directory on the server (/opt/mssql-tools/bin). SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. Server is a Superdome with lots of CPUs and RAM. Here is an example of a valid SQL Server login. – sqlclr.

Servers 40

Servers Network Database Systems 40

Dynatrace

APRIL 21, 2022

Figure 1 – Individual Host pages show performance metrics, problem history, event history, and related processes for each host. Right-sizing is an iterative process where you adjust the size of your resource to optimize for cost. To do that, organizations must evolve their DevOps and IT Service Management (ITSM) processes.

Azure 178

Azure Monitoring Virtualization Metrics 178

SQL Performance

APRIL 14, 2021

Evaluating earlier solutions, one of the important factors in getting good performance was the ability to employ batch processing. Let’s examine the plans for two of the earlier solutions that utilized batch processing. But have we exploited it to the maximum extent possible? NullBits102400 ; GO. Table 'NullBits102400'.

C++ 112

C++ Servers Testing Code 112

Dynatrace

MAY 28, 2020

While Google’s SRE Handbook mostly focuses on the production use case for SLIs/SLOs, Keptn is “Shifting-Left” this approach and using SLIs/SLOs to enforce Quality Gates as part of your progressive delivery process. This will enable deep monitoring of those Java,NET, Node, processes as well as your web servers.

Engineering 185

Engineering Performance Metrics Best Practices 185

The Netflix TechBlog

SEPTEMBER 8, 2020

Functional Testing Functional testing was the most straightforward of them all: a set of tests alongside each path exercised it against the old and new endpoints. The Not-so-good In the arduous process of breaking a monolith, you might get a sharp shard or two flung at you.

Latency 233

Latency Cache Java Traffic 233

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

O'Reilly

DECEMBER 12, 2023

This ruling in itself raises many questions: how much creativity is needed, and is that the same kind of creativity that an artist exercises with a paintbrush? But reading texts has been part of the human learning process as long as reading has existed; and, while we pay to buy books, we don’t pay to learn from them.

Artificial Intelligence 104

Artificial Intelligence Media Google Processing 104

J. Paul Reed

AUGUST 7, 2023

The “root cause” [sic] was eventually identified and it was related subtle differences in server provisioning. Even though that remediation task was pretty minor — tweaking some low-level hardware settings on each physical server and rebooting — and could have been done quickly enough, there was intense debate on whether it should be done.

Engineering 52

Engineering Hardware Games Infrastructure 52

SQL Performance

OCTOBER 20, 2022

When SQL Server reads data under locking read committed isolation (the default for non-cloud offerings) and chooses row-level locking granularity, it normally only locks one row at a time. The engine processes the row through parent operators before releasing the shared lock prior to locking and reading the next row. Lock classes.

Testing 91

Testing Servers Cache Engineering 91

O'Reilly

JUNE 13, 2023

The process of going through ChatGPT to Wolfram and back was also painfully slow, much slower than using Wolfram Alpha directly or writing a few lines of Python. I didn’t get as many citations in return, possibly because we don’t have preprint servers like ArXiv, and have done little to protest journals’ proprietary lock on scholarship.

Google 86

Google Programming Database Testing 86

Tasktop

FEBRUARY 20, 2020

I Also like to spend a little bit of time stretching and doing light exercises, reading or playing with my daughter before I dive into some work. I enjoy the process of distilling information from various sources and putting it into a format that our trainees can easily digest and comprehend. Not a bad deal!

Software 52

Software Software Software Engineering Infrastructure 52

SQL Performance

NOVEMBER 30, 2021

SQL Server has a cost-based optimizer that uses knowledge about the various tables involved in a query to produce what it decides is the most optimal plan in the time available to it during compilation. However, nothing easily allows SQL Server to determine what percentage of the leaf level for each index of a table is already in memory.

Efficiency 54

Efficiency Servers Database Cache 54

SQL Performance

JANUARY 12, 2022

Despite the poor performance, working on the solution is an interesting exercise. Also, there's potential here to benefit from batch processing. If you're using SQL Server 2019 or earlier, you can use the following logically equivalent alternative: CASE WHEN EndDemand < EndSupply THEN EndDemand ELSE EndSupply END.

Code 116

Code Servers Performance Azure 116

HammerDB

JULY 16, 2021

log 2 Virtual Users Created with Monitor VU hammerdb>vurun Vuser 1:RUNNING Vuser 1:Beginning rampup time of 2 minutes Vuser 2:RUNNING Vuser 2:Processing 10000000 transactions with output suppressed. software running on the same server. on this server. /hammerdbcli HammerDB CLI v4.2 Vuser 1:Rampup 2 minutes complete.

Virtualization 57

Virtualization Performance C++ Database 57

Particular Software

DECEMBER 9, 2019

I once had a client who started out with a very noncomplex server infrastructure. The hosting provider had given them ownership of an internal IP subnet, and so they started out with two load-balanced public web servers: X.X.X.100 It's easy enough to upgrade load-balanced web servers. It's not so easy with a junk drawer server.

Wireless 52

Wireless DevOps Infrastructure Network 52

SQL Performance

JUNE 10, 2020

This month and the next I’m going to cover the physical processing aspects of derived tables. In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Does it get persisted on disk, and how does SQL Server handle memory for it?

C++ 109

C++ Database Servers Code 109

Percona

AUGUST 8, 2023

Unfortunately, this topic is more of an art than a science, given that there is really no foolproof algorithm or approach that can tell you exactly where you might hit a bottleneck with server performance. Conclusion Capacity planning is not something you do once a year or more as part of a general exercise.

Traffic 88

Traffic Cache Monitoring Database 88

MachMetrics

JANUARY 4, 2019

This PageSpeed service offers two types of package for web servers: Apache module and Nginx module. After integrating PageSpeed Module components on the server side, the architecture and files of your website will automatically rewrite for optimal performance. Have you used the Google PageSpeed Module on your server?

Speed 60

Speed Website Open Source Google 60

SQL Performance

JUNE 10, 2020

This month and the next I’m going to cover the physical processing aspects of derived tables. In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Does it get persisted on disk, and how does SQL Server handle memory for it?

C++ 93

C++ Database Servers Code 93

The Morning Paper

AUGUST 27, 2019

In a distributed setting with weak consistency, an object is replicated across a set of servers. Unfortunately, to date, the task of identifying whether or not an object is actually invariant confluent has remained an exercise in human proof generation… Hand-written proofs of this sort are unreasonable to expect from programmers.

Programming 59

Programming Processing Database Systems 59

HammerDB

APRIL 19, 2023

Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. For the network, we can use Iperf to assess the network bandwidth between the client and the database server to ensure it will be enough to meet our peak requirement.

Performance 54

Performance Benchmarking Cache Storage 54

CSS - Tricks

APRIL 1, 2021

With all of this in mind, I thought improving the speed of my own version of a slow site would be a fun exercise. This is the process of turning HTML, CSS and JavaScript into a fully fleshed out, interactive website. It begins with retrieving the HTML from the server and converting this into the Document Object Model (DOM).

Cache 92

Cache Social Media Media Website 92

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

The Morning Paper

JULY 4, 2019

They use a combination of timeouts, retries, and fallbacks to try to mitigate the effects of these failures, but these don’t get exercised as often as the happy path, so how can we be confident they’ll work as intended when called upon? RPCs at Netflix are wrapped as Hystrix commands. On error rates.

Latency 77

Latency Engineering Metrics Traffic 77

O'Reilly Software

MARCH 7, 2018

Working with never-ending streams of data necessitates continuous processing of it, ensuring the system keeps up with the load patterns it is exposed to, and always provides real-time, up-to-date information. Sadly, it is very common to write logic that deeply couples the notion of IO with the processing of that IO.

Transportation 72

Transportation Java Programming Architecture 72

The Netflix TechBlog

OCTOBER 14, 2021

The “USERTrust RSA Certificate Authority” was relatively new and not directly trusted by many clients and so most servers would send certificates 1, 2, and 3 to clients. The end result is the first major update to BetterTLS since its first release : a new suite of tests to exercise TLS implementations’ certificate path building.

Servers 165

Servers Testing Best Practices Java 165

O'Reilly

JANUARY 17, 2023

You might say that the outcome of this exercise is a performant predictive model. Second, this exercise in model-building was … rather tedious? You need to coordinate with stakeholders and product managers to suss out what kinds of models you need and how to embed them into the company’s processes. And it made sense.

Tuning 133

Tuning Open Source AWS Software 133

O'Reilly

OCTOBER 19, 2021

While there isn’t an authoritative definition for the term, it shares its ethos with its predecessor, the DevOps movement in software engineering: by adopting well-defined processes, modern tooling, and automated workflows, we can streamline the process of moving from development to robust production deployments.

DevOps 140

DevOps Software Engineering Infrastructure Open Source 140

All Things Distributed

OCTOBER 2, 2017

percent availability in the event of a server, a rack of servers, or an Availability Zone failure. DynamoDB automatically re-distributes your data to healthy servers to ensure there are always multiple replicas of your data without you needing to intervene. Auto Scaling is on by default for all new tables and indexes.

Internet 128

Internet Internet AWS Performance 128

All Things Distributed

NOVEMBER 21, 2017

Amazon ElastiCache embodies much of what makes fast data a reality for customers looking to process high volume data at incredible rates, faster than traditional databases can manage. However, the slots must be moved manually on the server side. Redis's microsecond latency has made it a de facto choice for caching.

Games 112

Games Retail Latency Education 112

Smashing Magazine

AUGUST 5, 2021

We want to ensure that the input is perfectly correct before the data is even sent to the server. When large parts of the interface are disabled , most customers will assume that the system is busy , and some process is happening in the background on the page. We want to avoid wasteful jumps back and forth between error messages.

Design 145

Design Transportation Code Systems 145

All Things Distributed

NOVEMBER 15, 2010

From financial processing and traditional oil & gas exploration HPC applications to integrating complex 3D graphics into online and mobile applications, the applications of GPU processing appear to be limitless. Because of its focus on latency, the generic CPU yielded rather inefficient system for graphics processing.

AWS 136

AWS Latency Programming Architecture 136

The Netflix TechBlog

OCTOBER 21, 2019

Where other systems may take over ten minutes to process metrics accurately, Mantis reduces that from tens of minutes down to seconds, effectively reducing our Mean-Time-To-Detect. Instead, we should process and serve events one at a time as they arrive. Operational use cases are inherently time sensitive by nature.

Open Source 148

Open Source Metrics Engineering Processing 148

The Netflix TechBlog

OCTOBER 21, 2019

Where other systems may take over ten minutes to process metrics accurately, Mantis reduces that from tens of minutes down to seconds, effectively reducing our Mean-Time-To-Detect. Instead, we should process and serve events one at a time as they arrive. Operational use cases are inherently time sensitive by nature.

Open Source 101

Open Source Metrics Engineering Processing 101

The Netflix TechBlog

OCTOBER 21, 2019

Where other systems may take over ten minutes to process metrics accurately, Mantis reduces that from tens of minutes down to seconds, effectively reducing our Mean-Time-To-Detect. Instead, we should process and serve events one at a time as they arrive. Operational use cases are inherently time sensitive by nature.

Open Source 100

Open Source Metrics Engineering Processing 100