SQL Performance

MARCH 17, 2020

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. Each test result represents the best of ten runs, with all required data and index pages in memory. Row Store Clustered Index.

Servers 86

Servers Tuning Database Efficiency 86

Dynatrace

JANUARY 20, 2020

Having released this functionality in a Preview Release back in October 2019, we’re now happy to announce the General Availability of our SAP ABAP real user monitoring. Aggregated T-code scorecards give you immediate insights (for example, the slowest performing T-code) so you always know where to look first. Dynatrace news.

Monitoring 153

Monitoring Performance Infrastructure Network 153

Scalegrid

MAY 2, 2019

We often undertake testing of failover characteristics of various MongoDB drivers to qualify them for production use cases, or when our customers ask us for advice. Testing Failover Behavior. You can test the resilience of your applications by inducing failovers while your workload runs. servers.mongodirector.com:27017 (X.X.X.X)

Testing 55

Testing Network Database Servers 55

SQL Server According to Bob

JULY 31, 2018

Update Oct 2018 – SQL Server 2019 CTP 2.0. SQL Server 2019 changes the DELTE On CLOSE behavior used on Linux installations. I changed the code to call unlink after open completes preventing new access to the file. I even tested the following scenario. The file can be seen from a Windows directory listing.

Servers 40

Servers Software Engineering Systems Monitoring 40

SQL Performance

APRIL 13, 2022

Use the following code to create a table called T1 and populate it with a small set of sample data: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. To test the performance of your solution, you’ll need to populate the table with larger volumes of sample data. Finally, I’ll compare the performance of the different solutions.

C++ 136

C++ Strategy Testing Servers 136

Percona

MARCH 7, 2019

The server is a small instance: Models | 6xIntel(R) Xeon(R) CPU E5-2430 0 @ 2.20GHz 10GB RAM This symptom can be caused by various different reasons. In other words, the time the CPU was executing user code, such as MySQL. There could be more, but this particular query was definitely hurting the performance of the server.

C++ 99

C++ Traffic Servers Monitoring 99

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. Let’s proceed to performance testing.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

JANUARY 12, 2022

Use the following code to create the table and populate it with a small set of sample data: DROP TABLE IF EXISTS dbo. ( ID INT NOT NULL IDENTITY ( 1 , 1 ) CONSTRAINT pk_Auctions PRIMARY KEY CLUSTERED , Code CHAR ( 1 ) NOT NULL. Auctions ( ID , Code , Quantity ) VALUES. ( Auctions. (

Code 116

Code Servers Performance Azure 116

SQL Performance

MARCH 29, 2022

When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. The bigint type isn’t used for server-side parameterization.

Cache 90

Cache Servers Database Testing 90

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. That community spans expertise and industries, putting diverse skill sets and fresh perspectives into the review and improvement of code. Then those tools have to be configured and tested to work together.

Open Source 78

Open Source Healthcare Social Media Database 78

Scalegrid

SEPTEMBER 16, 2019

You can remotely access and navigate another database server. The dashboard lets you monitor server activities such as database locks, connected sessions, and prepared transaction. Since pgAdmin is a web application, you can deploy it on any server and access it remotely. 2019 Comparison Click To Tweet.

Open Source 262

Open Source Database Azure Cloud 262

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. Let’s proceed to performance testing.

C++ 61

C++ Servers Testing Processing 61

Smashing Magazine

MAY 25, 2021

A number of sites moved to font-display: swap when this first came out, and Google Fonts even made it the default in 2019. The amount of code isn’t huge, but it still feels like a little bit more effort than it should be. However, beyond that it didn’t really solve the problem.

Operating System 143

Operating System Google Website Cache 143

SQL Performance

MAY 11, 2022

You can download the source code to create and populate this database here. I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. SQL Server doesn't currently support an efficient combination of a parallel order-preserving input prior to a parallel batch-mode Window Aggregate operator.

C++ 133

C++ Database Servers Code 133

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

TechBeacon Testing

SEPTEMBER 11, 2019

Usually when people think of code, they envision programs executed by computers to do X, Y, or Z. Infrastructure as code (IaC) is different. It is a method you can use to define a configuration model that represents a piece of your server environment.

Programming 45

Programming Infrastructure Servers Code 45

KeyCDN

MARCH 14, 2019

Here is a roundup of front end web development trends to keep an eye on in 2019. Frontend Frameworks If you’re not using a frontend framework like React, Vue.js, or Angular to help build your projects, then 2019 is a good year to start. It can be used to decouple your frontend from your backend and improve server efficiency.

Development 101

Development Blockchain Serverless Social Media 101

KeyCDN

SEPTEMBER 12, 2019

Most of you have probably seen the following Google PageSpeed Insights optimization suggestion at one point or another when running a speed test: By compressing and adjusting the size of … you can save 14.2 Well, according to HTTP Archive , as of June 1, 2019 the average desktop page is 1,896.8

Social Media 106

Social Media Media Google Website 106

Dynatrace

JUNE 9, 2021

A web application is any application that runs on a web server and is accessed by a user through a web browser. Web application security is the process of protecting web applications against various types of threats that are designed to exploit vulnerabilities in an application’s code. What is web application security?

Open Source 181

Open Source Entertainment Tuning Internet 181

O'Reilly

NOVEMBER 12, 2019

Rather than buying racks and racks of servers that need to handle the maximum potential traffic and be idle most of the time, it seems that serverless’ method of paying by compute is proving to be beneficial to the bottom lines of organizations. The third stand-out issue was “no server maintenance.” 1 reported benefit.

Serverless 88

Serverless Architecture FinTech Infrastructure 88

Smashing Magazine

FEBRUARY 2, 2022

Improving JavaScript Bundle Performance With Code-Splitting. Improving JavaScript Bundle Performance With Code-Splitting. It’s a common misconception that the code which is produced by the framework build tools (Webpack, for example) is fully optimized and cannot be improved upon any further. The answer lies in code-splitting.

Code 89

Code Performance Network Website 89

SQL Performance

OCTOBER 14, 2020

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. Substitution/unnesting. ( SELECT TOP ( 9223372036854775807 ) *.

C++ 140

C++ Servers Code Efficiency 140

Smashing Magazine

JULY 16, 2019

2019-07-16T14:30:59+02:00. 2019-07-16T14:35:52+00:00. A few caveats before we begin: Data scraping involves increasing the server load for the site that you’re scraping, which means a higher cost for the companies hosting the site and a lower quality experience for other users of that site. We’ll start with a basic spider.

Scalability 87

Scalability Website C++ Servers 87

SQL Performance

FEBRUARY 10, 2021

I’ll do my testing in tempdb, enabling IO and TIME statistics: SET NOCOUNT ON ; USE tempdb ; SET STATISTICS IO , TIME ON ; The fastest solution from last month applies a join with a dummy table that has a columnstore index to get batch processing. Here’s the code to create the dummy table: DROP TABLE IF EXISTS dbo. BatchMe ; GO.

C++ 124

C++ Servers Testing Code 124

Testsigma

NOVEMBER 16, 2021

We shall also see how decisions are made in an enterprise and why cross-browser testing is the most important thing in 2021 to sustain a healthy business. In the summer of 2019, British Airways faced a technical issue on its website. Throughout this post, we shall see how enterprises behave and what makes them an “ enterprise ”.

Testing 52

Testing Website Small Business Internet 52

Scalegrid

AUGUST 15, 2019

Read on to find out which is the best MongoDB GUI for you, updated for 2019, that contain these key features: A good visual editor to write and edit queries faster. Should have an excellent way to measure server and query performance. It’s further enhanced by an in-place code editor which is also available in all three views.

Database 40

Database Servers Monitoring Availability 40

The Netflix TechBlog

MARCH 1, 2021

Dealing with production issues became an expensive chore that placed a tax on all developers because infrastructure code was all mixed up with application code. Local development tools including specialized test runners, code generators, and a command line interface. Productivity?—?Local Delivery?—?A

Serverless 228

Serverless Media Latency Social Media 228

Smashing Magazine

OCTOBER 15, 2018

Smart Bundling: How To Serve Legacy Code Only To Legacy Browsers. Smart Bundling: How To Serve Legacy Code Only To Legacy Browsers. 2019-04-29T18:34:58+00:00. A Practical Guide To Shipping Efficient Code. js', }, module: { rules: [ { test: /.jsx?$/, jsx?$/, use: "babel-loader" }, { test: /.css$/, Difference.

Code 58

Code Retail Mobile Website 58

Smashing Magazine

SEPTEMBER 3, 2019

2019-09-03T12:30:00+02:00. 2019-09-03T11:35:16+00:00. Managing the deployment of a website used to be easy: It simply involved uploading files to the server through FTP and you were pretty much done. Automating Website Deployments Through Buddy. Automating Website Deployments Through Buddy. Leonardo Losoviz.

Website 82

Website Serverless AWS Lambda 82

Tasktop

OCTOBER 16, 2019

He casually mentioned that he found a really confusing test failure the other day that we should pair up on. Ready to start digging into some code again, he gave me the broad picture: Internally we use Log4j2 as our logging solution of choice (with the various off-the-shelf adapters to handle 3rd libraries with different log frameworks).

C++ 9

C++ Servers Testing Infrastructure 9

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server.

IoT 61

IoT Servers Development Cache 61

SQL Performance

OCTOBER 14, 2020

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. Substitution/unnesting. ( SELECT TOP ( 9223372036854775807 ) *.

C++ 52

C++ Servers Code Efficiency 52

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! The broken Java stacks turned out to be beneficial: They helped group together the os::javaTimeMillis() calls which otherwise might have have been scattered on top of different Java code paths, appearing as thin stacks everywhere. in total.

Speed 126

Speed Java AWS Virtualization 126

SQL Performance

APRIL 18, 2022

It’s no surprise even highly experienced SQL Server users tend to get this wrong, given the contradictory information often supplied to us. Let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14, with database compatibility set to 150. Parameterization Not Attempted. Users AS U. sp_configure.

Cache 58

Cache Servers Database Testing 58

MachMetrics

JUNE 30, 2021

Many people often confuse site speed with page speed grades of performance testing tools, which are actually calculated based on multiple factors of a page including its loading speed. John Mueller answered “YES” to this question in 2019, “site speed is definitely a ranking factor?”. Check the calculator image below –.

Cache 78

Cache Speed Google Website 78

SQL Performance

SEPTEMBER 6, 2022

Testing environment. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. DECRYPTION BY CERTIFICATE Banana ; Start : -- Recreate the test table. BEGIN TRANSACTION ; -- Test statement(s).

Database 98

Database Storage Testing Servers 98

Percona

JULY 15, 2023

Let’s test the following equivalent query: mysql> SELECT AVG(price) FROM products WHERE create_time BETWEEN '2019-10-01' AND '2019-11-01'; + + | AVG(price) | + + | 202.982582 | + + mysql> EXPLAIN SELECT AVG(price) FROM products WHERE create_time BETWEEN '2019-10-01' AND '2019-11-01'G 1.

Virtualization 77

Virtualization Speed Database Efficiency 77