SQL Server According to Bob

JUNE 27, 2016

To some of you SQL Server On Linux is old news from various announcements made a couple of months ago. Yes, SQL Server runs on Linux! It was Jan 2015, in my previous supportability role, that I started looking at SQL Server on Linux. I proceeded to install an Ubuntu VM and the internal build of SQL Server on Linux.

Servers 40

Servers Games Azure Software Engineering 40

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. With lots of guidance from other platform and backend teams, we took a 3-pronged approach to ensure correctness for each route migrated.

Latency 233

Latency Cache Java Traffic 233

Scalegrid

APRIL 16, 2020

AWS Security Groups and Azure Network Security Groups allow you to lock down access to your servers through advanced virtual firewalls. Use Follower Clusters keep two independent database systems (of the same type) in sync so you can analyze, optimize and test app performance for MySQL, PostgreSQL and MongoDB® database. Security Groups.

Cloud 242

Cloud Azure AWS Database 242

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

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. Now that I have 3 kids, I’ve been limited to the gym but it’s a great way to get exercise and keep my mind sharp. . We have a lot of hills in our area so I can really get a good workout.

Software 52

Software Software Software Engineering Infrastructure 52

SQL Performance

JULY 1, 2021

There was the case where a colleague constantly promoted the deprecated backward compatibility view sys.sysprocesses instead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler. name ) + N'.' + QUOTENAME ( o. name ) + N' '.

C++ 58

C++ Database Servers Performance 58

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. SQL Server solves this problem using lock classes. SQL Server needs to hold locks in this case to ensure the by-reference LOB pointers remain valid.

Testing 91

Testing Servers Cache Engineering 91

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

JANUARY 12, 2022

Despite the poor performance, working on the solution is an interesting exercise. You can enable its consideration without the requirements of batch mode on rowstore , e.g., using SQL Server 2019 Enterprise or later, by creating the following dummy columnstore index: CREATE NONCLUSTERED COLUMNSTORE INDEX idx_cs ON dbo.

Code 116

Code Servers Performance Azure 116

O'Reilly

JUNE 13, 2023

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. An essay isn’t an exercise in providing N*1000 words; it’s the outcome of a thought process that involves engaging with the subject matter.

Google 83

Google Programming Database Testing 83

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

DECEMBER 27, 2019

This is a copy of the data, on an idle server (8 cores, 64GB RAM), with plenty of disk space (well over 6TB). mdf' ) TO FILEGROUP FG_CCI ; --. The post Fun with (columnstore) compression on a very large table – part 1 appeared first on SQLPerformance.com.

Database 70

Database Storage Hardware Efficiency 70

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT. That's pretty neat!

C++ 111

C++ Database Servers Code 111

SQL Performance

JUNE 10, 2020

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. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions.

C++ 109

C++ Database Servers Code 109

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? It may not be possible if you use a generative model configured as a chat server by itself. But that isn’t the end of the story.

Artificial Intelligence 101

Artificial Intelligence Media Google Processing 101

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

SQL Performance

JUNE 10, 2020

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. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions.

C++ 93

C++ Database Servers Code 93

SQL Performance

JANUARY 11, 2021

So when their compiled application sends ad hoc queries to SQL Server, particularly as a prepared statement, and when we don't have the freedom to add or change indexes, several tuning opportunities are immediately off the table. In this case, we had a table with a couple million rows.

Cache 59

Cache Tuning Database Performance 59

The Agile Manager

SEPTEMBER 30, 2012

Development teams have a lot of specialists, both role (business analyst, developer, user experience designer, quality assurance analyst) and technical (mobile client developer, server-side Java developer, web client developer, etc.) We can invest in people to become mobile solution developers who can write client and server code.

Mobile 49

Mobile Code Java Software 49

Sutter's Mill

JANUARY 11, 2021

For example, you might make different decisions about enabling assertions if your “run time” is an end user’s machine, or a server farm, or a honeypot. Here they are: Of course this can be even more nuanced. Notes With thanks to Wikipedia for the first two references. [1] Goldstine and J. von Neumann. 2] Alan Turing.

C++ 58

C++ Programming Code Testing 58

Percona

DECEMBER 5, 2023

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. The scenario Service considerations In this exercise, we wanted to perform a major version upgrade from PostgreSQL v12.16 done server stopped 16.

Database 78

Database Traffic C++ Servers 78

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),

Database 105

Database Servers Open Source Tuning 105

Dynatrace

JUNE 27, 2022

Data collected on page load events, for example, can include navigation start (when performance begins to be measured), request start (right before the user makes a request from the server), and speed index metrics (measure page load speed). Finally, combining RUM and synthetic monitoring data can make troubleshooting faster and easier.

Best Practices 172

Best Practices Monitoring Wireless Traffic 172

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

Dynatrace

MAY 15, 2020

So, I gave the following scenario: You are the Cyber Security resource attached to the DevOps team and the team just received a problem alert from Dynatrace, relating to user performance degradation localized to a single server, specifically caused by higher than normal CPU and network packets sent.

Government 222

Government DevOps Infrastructure Network 222

The Agile Manager

NOVEMBER 26, 2008

User Interface, middle tier, server side, database, specialists in things like ERP systems) or by component (e.g., This means that lots of development tasks may be flagged as “complete” but they’re complete only by assertion of a developer, not by “fact” of somebody who has exercised the code from end-to-end.

Code 40

Code Servers Engineering Programming 40

SQL Performance

APRIL 14, 2021

Scan count 2, logical reads 0, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 8, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0. Table 'NullBits102400'. Table 'NullBits102400'. Paul’s solution.

C++ 112

C++ Servers Testing Code 112

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 90

Traffic Cache Monitoring Database 90

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? If your business relied on a hard-and-fast rule, or a predictable sequence of events, someone was bound to write code to do the work and throw that on a few dozen servers to scale it out.

Tuning 130

Tuning Open Source AWS Software 130

Dynatrace

MAY 28, 2020

If you have a distributed environment with multiple servers hosting your webservers, app servers, and database, I suggest you install the OneAgent on all these servers to get full end-to-end visibility. This will enable deep monitoring of those Java,NET, Node, processes as well as your web servers. test name, test step.

Engineering 189

Engineering Performance Metrics Best Practices 189

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

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. It begins with retrieving the HTML from the server and converting this into the Document Object Model (DOM). The traditional path of delivering content is to hit the server, request data, and wait for it to return.

Cache 92

Cache Social Media Media Website 92

Dynatrace

APRIL 21, 2022

Once you have and understand this data, you can identify issues, find opportunities for improvement, and eliminate risks before you go through a costly migration exercise. Serverless – Deploy OneAgent via ARM templates or Site Extensions for Azure App Server or Azure Functions to get code level insights.

Azure 184

Azure Monitoring Virtualization Metrics 184

HammerDB

JULY 16, 2021

software running on the same server. This is the same server, same OS and same HammerDB client, the only difference is in the server software. on this server. When we graph the result, we now get a much better picture of the full capabilities of the MySQL 5.7 Now we can see that MySQL 8.0 at 1.51X over MySQL 5.7.33.

Virtualization 57

Virtualization Performance C++ Database 57

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

O'Reilly

OCTOBER 19, 2021

but to reference concrete tooling used today in order to ground what could otherwise be a somewhat abstract exercise. There are countless systems that can perform this task for small DAGs on a single server. The intention behind the examples is not to be comprehensive (perhaps a fool’s errand, anyway!),

DevOps 138

DevOps Software Engineering Infrastructure Open Source 138

Brendan Gregg

JUNE 30, 2018

sounds like a homework exercise of purely academic value. My colleague began analysis using a packet sniffer on the target, to see if packets were really taking that long to be returned by the server. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec? This is really asking "what's the limiter?" He saw nothing.

Benchmarking 54

Benchmarking Latency Cache Network 54