SQL Performance

JANUARY 10, 2020

Earlier this week, Microsoft announced SQL Server 2019 Cumulative Update #1. To update your local Docker image: docker pull mcr.microsoft.com/mssql/server: 2019 -latest. Build a slipstreamed installer once ( Randolph West explains this process for 2017 here ), and use that for consistency across your environment.

Servers 52

Servers Testing Processing 52

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server. Installation and support of SSRS can be confusing.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

AUGUST 14, 2019

GetNums ( 1 , @rows_per_partition ) AS RPP ; Our pitfall has both a logical side to it with a potential logical bug as well as a performance side with a performance penalty. The performance penalty is relevant only when the window function is optimized with row-mode processing operators. It took this query about 4.5

Best Practices 108

Best Practices Servers Database Azure 108

SQL Server According to Bob

DECEMBER 26, 2017

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Q uick XE Trace ’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release. Here is an example using the SQL Server SSMS 2017 against my SQL 2016 server.

Servers 40

Servers Software Engineering Engineering Availability 40

SQL Performance

SEPTEMBER 12, 2019

As an example with our task, suppose that you don't realize that the grouping element is determined implicitly, and you come up with the following query: SELECT shipperid , [ 2017 ] , [ 2018 ] , [ 2019 ] FROM Sales. So you're expecting to see only three rows in the result. 830 rows affected).

Best Practices 103

Best Practices C++ Code Design 103

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MariaDB Server, on the other hand, is a fork of MySQL 5.5. Elevate your MariaDB environment with Percona Support for MariaDB.

Open Source 52

Open Source Servers Storage Scalability 52

Dynatrace

JUNE 15, 2023

If your application runs on servers you manage, either on-premises or on a private cloud, you’re responsible for securing the application as well as the operating system, network infrastructure, and physical hardware. The financial services sector alone saw a surge in web application and API attacks of 257% from 2021 to 2022.

Cloud 179

Cloud Open Source Architecture Monitoring 179

Rigor

SEPTEMBER 11, 2019

Reading time 16 min Whether you’re a web performance expert, an evangelist for the culture of performance, a web engineer incorporating performance into your process, or someone new to the web performance entirely, you probably identify as curious, excited about new ideas, and always learning. Rick Byers.

Performance 89

Performance Education Google Website 89

The Netflix TechBlog

DECEMBER 14, 2020

The mystery begins Towards the end of 2017, I was on a conference call to discuss an issue with the Netflix application on a new set top box. In Ninja, this job is performed by an Android Thread. I knew epoll() performance isn’t guaranteed, so I suspected something was affecting epoll() in a systematic way. aka “Lollipop”.

Engineering 352

Engineering Code Hardware Open Source 352

SQL Server According to Bob

FEBRUARY 22, 2018

Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not function as expected. SQL Server’s NewSequentialId () calls the Windows API UuidCreateSequential , which is limited in SQLPAL, prior to the CU 4 update. Server B may be generating uuids that sort before those from Server A.

Servers 40

Servers Software Engineering Database Network 40

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.

C++ 111

C++ Database Servers Code 111

Tim Kadlec

JUNE 21, 2022

HTTP/3 work started in 2012 with Google working on QUIC, adopted by IETF in 2017, RFC’s published in June 2022. No server push! The RSVP problem: HTTP/3 might be blocked on the network or may not be enabled on the server. So the browser will only try HTTP/3 if it’s certain the server supports it. What and Why?

Network 64

Network Mobile Google Cache 64

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). DtcGetTransactionManager contacts the host, performing a remote registry access to determine the connection and proxy information. Once the connection to SQL Server is established the APP executes the odbc!

Servers 40

Servers Azure Engineering Java 40

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. It’s reliable, robust, feature-rich, and performant. Additionally, the IT team must have the expertise to maintain the deployment at peak performance. It all helps ensure the cluster’s peak performance.

Open Source 76

Open Source Healthcare Social Media Database 76

SQL Server According to Bob

JULY 17, 2018

When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 The Linux, sqlservr, WATCHDOG can perform a similar role.

Servers 40

Servers Processing Software Engineering Traffic 40

SQL Performance

FEBRUARY 12, 2020

Curiously, SQL Server's query processor already supports an internal comparison operator IS, which uses the same semantics as the desired IS operator I described here. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. Consider the following query as an example: SELECT orderid , shippeddate FROM Sales.

C++ 120

C++ Code Servers Database 120

SQL Performance

AUGUST 11, 2021

Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. SQL Server Management Studio already has IntelliSense support, as shown in Figure 1: Figure 1: Intellisence support for DATE_BUCKET in SSMS. 2017 343 495118.14

Azure 139

Azure Code Database Servers 139

SQL Performance

DECEMBER 11, 2019

WHERE NOT ( shippeddate = '20190102' ) ; This query returns the following output: orderid shippeddate -- -- 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. WHERE shippeddate IS NOT NULL ; This query generates the following output: orderid shippeddate -- -- 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12.

Best Practices 117

Best Practices C++ Database Code 117

SQL Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Pedro makes it his mission to help customers with SQL Server Performance.

Engineering 40

Engineering Azure Best Practices Servers 40

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. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Performance is competitive at around 15ms. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

OCTOBER 26, 2021

The SQL Server query optimizer makes use of statistics during query compilation to help determine the optimal query plan. Perform regular statistics maintenance, so automatic synchronous or asynchronous statistics updates don’t happen at all. Most preemptive waits are when a thread makes a call outside of SQL Server (e.g.,

Servers 55

Servers Metrics Database Performance 55

SQL Performance

JUNE 5, 2019

One of the more perplexing problems to troubleshoot in SQL Server can be those related to memory grants. Some queries need more memory than others to execute, based on what operations need to be performed (e.g. The post Troubleshooting Variable Memory Grants in SQL Server appeared first on SQLPerformance.com. sort, hash).

Servers 41

Servers Cache Database Metrics 41

SQL Server According to Bob

DECEMBER 18, 2018

I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article. SQL Server does NOT do this, in fact I made sure SQL Server on Linux does not allow this to occur. This issue does NOT impact SQL Server database, log and backup files.

Servers 40

Servers Media Cache Software Engineering 40

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. ” Nothing nefarious there.

Open Source 79

Open Source Programming Database Servers 79

MachMetrics

DECEMBER 14, 2019

With another year winding down, it’s time for us to take stock of how our site performance compares to the average page load times for 2020. As you know, there are many metrics that determine a website’s page speed, and we can’t look at just one of them to determine how performant our site is.

Best Practices 105

Best Practices Speed Mobile Google 105

Dotcom-Montior

JUNE 25, 2020

These certificates are then activated on the company’s website which ensures that a secure connection is always set up between the web browser and the web server. SSL certificates maintain the security of data between servers. CDNs essentially act as the backbone for high speed internet content delivery and performance.

Monitoring 77

Monitoring Website Internet Internet 77

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. Only currently open file descriptors may continue to perform reads, writes and fstat activities. Bob Dorr – Principal Software Engineer SQL Server. Restart the VM.

Servers 40

Servers Software Engineering Systems Monitoring 40

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. “.

Servers 90

Servers Media Cache Storage 90

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

SQL Performance

MAY 1, 2020

In a recent tip , I described a scenario where a SQL Server 2016 instance seemed to be struggling with checkpoint times. A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions. How It Works: When is the FlushCache message added to SQL Server Error Log? writes/sec average throughput: 46.96

C++ 58

C++ Database Servers Storage 58

All Things Distributed

NOVEMBER 13, 2018

Since then, AWS has added another PoP in Palermo in 2017. Lamborghini, the world-famous manufacturer of elite, luxury sports cars based in Italy, has been using AWS to reduce the cost of their infrastructure by 50 percent, while also achieving better performance and scalability. Today, their time-to-market is close to zero.

AWS 167

AWS Energy Automotive Traffic 167

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

Virtualization 111

Virtualization AWS Hardware Storage 111

The Morning Paper

JUNE 6, 2019

The Federated Averaging algorithm addresses one of the key challenges in making this practical: reducing the communication volume (by 10-100x) between the model server and the devices. Secure aggregation was introduced in a 2017 paper by Bonawitz et al., ‘ Practical secure aggregation for privacy-preserving machine learning.’

Systems 71

Systems Design Google Servers 71

MachMetrics

FEBRUARY 7, 2019

.” Look put these stats on some numbers: Effect on Sale: 79% of customers who report dissatisfaction with website performance are less likely to buy from that same site again. It is easy to check pages and make minor tweaks to coding, server config, or optimization features to see a significant improvement in loading time.

Speed 93

Speed Website Performance Website Mobile 93

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. of the population were Internet users.

Internet 48

Internet Internet Speed Network 48

SQL Performance

FEBRUARY 17, 2022

Since SQL Server 2005, the trick of using FOR XML PATH to denormalize strings and combine them into a single (usually comma-separated) list has been very popular. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. ( 1 Pink Floyd, New Order, The Hip 2 Zamfir, ABBA. FavoriteBands.

Servers 82

Servers Code Efficiency Performance 82

Rigor

MARCH 20, 2018

I recently was asked the following question by an online retailer: “Why should I invest in monitoring the user experience when I already have monitoring for our database, infrastructure, app server, and network?”. 38% of all sites measured in Sept 2017 (~500K) are more than 75% 3rd party content. The Rise of Cloud Computing.

Monitoring 40

Monitoring Retail Ecommerce Infrastructure 40