SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. SQL Server 2019 introduces batch mode on rowstore support, so you can get batch-mode processing even if there's no columnstore indexes present on the data.

Best Practices 108

Best Practices Servers Database Azure 108

High Scalability

NOVEMBER 30, 2018

during the 2017-18 academic year, on top of a 3.3% ” @emileifrem : Adobe used 125 MongoDB servers to run their activity feed. It was replaced by 48 Cassandra servers. servers of Neo4j. The scalability of a native graph database. They'll love it and you'll be their hero forever. decline the year before.".

Internet 28

Internet Internet Scalability Blockchain 28

SQL Server According to Bob

SEPTEMBER 25, 2017

Scott Guthrie and Rohan Kumar officially made the announcement today at Ignite that SQL Server 2017 will be generally available on October 2nd, 2017. Andrew Brust also wrote a very nice article detailing out all the great new features that come with SQL Server 2017. Check out ScottGu’s blog post at: [link].

Servers 40

Servers Availability Tuning Database 40

SQL Server According to Bob

SEPTEMBER 27, 2017

Please check out a new blog post I created detailing how SQL Server 2017 is Fast, Built-In. And we are the fastest database everywhere you need it: On the planet or in the cloud. And we are the fastest database everywhere you need it: On the planet or in the cloud. Hope to see you there. Microsoft.

Servers 40

Servers Tuning Database Cloud 40

SQL Performance

OCTOBER 9, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. The EOMONTH function was introduced in SQL Server 2012. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT.

C++ 111

C++ Database Servers Code 111

SQL Performance

SEPTEMBER 12, 2019

In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Suppose for example that you want to query the Sales.Orders table in the TSQLV5 sample database. Implicit grouping with PIVOT. 830 rows affected).

Best Practices 103

Best Practices C++ Code Design 103

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.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115

Tuning Servers Monitoring Hardware 115

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 113

Internet Internet AWS Performance 113

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

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.

Best Practices 117

Best Practices C++ Database Code 117

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. In my examples, I’ll use the sample database TSQLV5. An event that took place on July 14 th , 2018 belongs to fiscal year 2017. 2017 343 495118.14

Azure 139

Azure Code Database Servers 139

SQL Performance

JULY 8, 2020

In my examples I’ll use sample databases called TSQLV5 and PerformanceV5. I should stress that in practice, there’s no actual process in which SQL Server converts the original query string with the nested logic to a new query string without the nesting. In Part 3 I started covering optimization considerations of derived tables.

Servers 110

Servers Code Performance Processing 110

SQL Performance

FEBRUARY 12, 2020

I'll continue using the sample database TSQLV5 like last month in some of my examples. You can find the script that creates and populates this database here , and its ER diagram here. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. DISTINCT predicate. 11063 2019-05-06 11067 2019-05-06 11069 2019-05-06.

C++ 120

C++ Code Servers Database 120

SQL Server According to Bob

DECEMBER 11, 2017

SQL Server 2019 CTP2. SQL Server 2019 adds broad support for distributed transactions (both MSDTC/OLE-TX and XA) to SQL Server on Linux. You can establish and use transactions between Linux and Linux or Linux and Windows instances of SQL Server or your application. Configuring MSDTC for SQL Server on Linux: [link].

Servers 40

Servers Database Software Engineering Engineering 40

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

JULY 9, 2019

I posted a suggestion to improve SQL Server by adding support for nested window functions. For example, suppose that you want to query the Sales.OrderValues view in the TSQLV5 sample database, and return for each customer and order date, the daily total of the order values, and the running total until the current day. 2 2017-09-18 88.80

Servers 83

Servers Availability Database Code 83

The Morning Paper

NOVEMBER 8, 2020

Back in 2017 the engineering team at Facebook had a problem. In Facebook’s implementation of NativeLoglet, seal simply sets a bit on a quorum of servers. NativeLoglet implements seal by setting a bit on a quorum of servers. Once the database was restored to five replicas, we reconfigured back. Every little helps!

Virtualization 126

Virtualization Latency Storage Systems 126

Brendan Gregg

NOVEMBER 28, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. This finally came to storage-optimized instance types in 2017 with the [i3 instance type], which used SR-IOV and the nvme storage driver.

Virtualization 40

Virtualization AWS Hardware Storage 40

Alex Russell

MARCH 6, 2021

TL;DR: A lot has changed since 2017 when we last estimated a global baseline resource per-page resource budget of 130-170KiB. To update our global baseline from 2017, we want to update our priors on a few dimensions: The evolved device landscape. The Moto G4 , for example. Here begins our 2021 adventure. Hard Reset.

Performance 127

Performance Network Metrics Cache 127

SQL Server According to Bob

APRIL 24, 2018

I also started my career developing on UNIX systems with C++ and databases like Ingres. When I joined Microsoft in 1993, I would embark on a 25 year journey working only on Windows laptops and Windows Server computers. Last October we released SQL Server 2017 including support for Linux and Docker Containers.

Servers 40

Servers Internet Internet Open Source 40

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 88

Availability Open Source Architecture Database 88

SQL Performance

MARCH 17, 2020

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

MachMetrics

DECEMBER 14, 2019

How fast is the average time to first byte (server delay)? In 2017, mobile internet usage passed desktop as the majority. How long is the average server delay? It is typically reduced via server-side optimizations, such as enabling caching and database indexes. How fast is the average page load time in 2020?

Best Practices 105

Best Practices Speed Mobile Google 105

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.

Open Source 86

Open Source Programming Database Servers 86

The Symphonia

DECEMBER 6, 2017

without web app servers?—?to Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. It’s still in early access, so no concrete news to report here, but a lot of people will be happy to be able to use a SQL database that has the operational properties of DynamoDB. We’re the experts!

Serverless 40

Serverless Lambda AWS Traffic 40

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ).

Open Source 83

Open Source Healthcare Social Media Database 83

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.

Servers 40

Servers Network Database Systems 40

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

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. This server is spending about a third of its CPU cycles just checking the time! What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 103

Speed Java AWS Virtualization 103

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Database architects working with MongoDB encounter specific challenges related to database systems and system growth.

Best Practices 76

Best Practices Traffic Database Servers 76

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. This is a just a presentation decision—the Concat and joins are still present in the code run by the SQL Server execution engine.

Servers 98

Servers Design Database Code 98

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. Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions.

C++ 58

C++ Database Servers Storage 58

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 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 Bob Dorr – Principle SQL Server Software Engineer.

Servers 40

Servers Processing Software Engineering Traffic 40

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. The issue is that even though SQL Server does support a short circuit concept at the physical processing level, there’s no assurance that it will evaluate the filter predicates in written order from left to right. Substitution/unnesting.

C++ 52

C++ Servers Code Efficiency 52