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

SQL Server According to Bob

FEBRUARY 11, 2019

SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to assist in transaction log processing activities. You may find the number of log write workers has been increased to 8 when running newer releases of SQL Server to accommodate larger systems. Total number NUMA nodes * 2.

Servers 40

Servers Availability Software Software 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

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. With a solution in hand for network performance, the next target was storage. ## 6. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

JULY 24, 2022

SQL Server 2012 went out of all forms of official support about two weeks ago, on July 12 th. Best approaches for running totals – updated for SQL Server 2012. In the very first post on this site, I compared the performance of long-standing running totals methods with the new windowing functions added in SQL Server 2012.

Servers 66

Servers Strategy Availability Processing 66

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

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

SQL Server According to Bob

FEBRUARY 13, 2020

​​ When the utility attempted to issue the thaw command the command would be queued, and the database could not return to an operational state until SQL Server was restarted. ​​ While the name can be any string it is commonly a Guid accommodating the ​​ uniqueness requirements.

Servers 40

Servers Availability Transportation Database 40

The Symphonia

DECEMBER 6, 2017

Traffic shaping / canary deployment was pre-announced at Serverless Conf NYC in October, and this is now available. there’s no inline debugging available in the Lambda Console.) without web app servers?—?to That means that 3GB functions might not see a linear speed bump for primarily single threaded functions. We’re the experts!

Serverless 40

Serverless Lambda AWS Traffic 40

Scalegrid

JULY 13, 2020

Compare PostgreSQL vs. Oracle functionality across available tools, capabilities and services. Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. Not available. Not available. Not available.

Open Source 244

Open Source Tuning C++ Database 244

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

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. The idea is to use secondary servers on your infrastructure for either reads or other administrative solutions. Network Connectivity: Establish a reliable network connection between the primary and replica servers. Restart the MySQL service.

Servers 52

Servers Database Availability Traffic 52

SQL Performance

JULY 9, 2019

This feature is currently not available in T-SQL. I posted a suggestion to improve SQL Server by adding support for nested window functions. At the date of this writing, there's not much information available out there about the true standard nested window functions. 2 2017-09-18 88.80 10248 85 2017-07-04 440.00

Servers 83

Servers Availability Database Code 83

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. In 2010, having seemingly gone all-in with the tenets of open source development , the company brought MongoDB to the market as an open source database server. 2017: MongoDB goes public, trading as MDB. Now, back to MongoDB itself.

Open Source 81

Open Source Programming Database Servers 81

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

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. To play a 60fps video, the highest frame rate available in the Netflix catalog, the device must render a new frame every 16.66 aka “Lollipop”.

Engineering 352

Engineering Code Hardware Open Source 352

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. To address these challenges, architects must design robust and scalable MongoDB databases and adopt appropriate sharding strategies that can efficiently handle increasing workloads while ensuring continuous availability. What is sharding in MongoDB?

Best Practices 71

Best Practices Traffic Database Servers 71

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. How-to documentation is readily available. It’s well-suited for organizations that require mission-critical applications with high availability. Bugs and security vulnerabilities are identified more quickly.

Open Source 78

Open Source Healthcare Social Media Database 78

SQL Performance

AUGUST 11, 2021

One is using a function called DATE_BUCKET , which at the time of writing is only available in Azure SQL Edge. 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. 2017 343 495118.14 DATE_BUCKET. OrderValues.

Azure 139

Azure Code Database Servers 139

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. Unfortunately, this clause is not yet available in T-SQL. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. Figure 1: Plan for Query 1.

C++ 120

C++ Code Servers Database 120

Dynatrace

FEBRUARY 25, 2021

since 2017, and many customers have used it with great success while we collected requirements for the next iteration of our Lambda extension. To handle N parallel requests, N Lambda instances need to be available, and AWS will spin up up to 1000 such instances automatically to handle 1000 parallel requests. What’s next.

Lambda 218

Lambda AWS Monitoring Serverless 218

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 ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40

Servers Azure Engineering Java 40

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

SQL Performance

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. You can skip the WHERE clauses if you are running SQL Server 2017. s = SUM ( T.

Performance 81

Performance C++ Storage Servers 81

MachMetrics

JUNE 30, 2021

Daniel An, Google, 2017. According to Google SOASTA research, 2017 the probability of page bounce rate increases with increasing page loading time, because it greatly improves the user experience. You can make beautiful-looking websites with the supports of millions of themes & plugins available. That’s a big problem.”

Cache 78

Cache Speed Google Website 78

SQL Performance

DECEMBER 11, 2019

Finally, I cover missing standard features related to NULL handling in T-SQL and suggest alternatives that are available in T-SQL. WHERE NOT ( shippeddate = '20190102' ) ; This query returns 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

The Morning Paper

NOVEMBER 8, 2020

USENIX is a nonprofit organisation committed to making content and research freely available – both conference proceedings and the recorded presentations of their events. 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.

Virtualization 126

Virtualization Latency Storage Systems 126

All Things Distributed

NOVEMBER 13, 2018

The AWS Europe (Milan) Region will have three Availability Zones and be ready for customers in early 2020. Currently we have 57 Availability Zones across 19 technology infrastructure Regions. Since then, AWS has added another PoP in Palermo in 2017. ENEL is one of the leading energy operators in the world. million unique visits.

AWS 167

AWS Energy Automotive Traffic 167

Scalegrid

APRIL 2, 2019

These results are pretty on-par with a 2017 survey by the Uptime Institute which found that 65% of enterprise workloads were still running in data centers owned and operated by those enterprises. using SQL Server, 17.3% So, how are PostgreSQL users choosing to host the clusters that power their applications? are using public clouds.

Database 185

Database Cloud Open Source Azure 185

Dynatrace

OCTOBER 17, 2019

We’re no longer living in an age where large companies require only physical servers, with similar and rarely changing configurations, that could be manually maintained in a single Datacenter. This will allow teams to start worrying about other things that have not been solved yet by the extensive tools already available.

Code 109

Code Infrastructure DevOps Serverless 109

SQL Performance

JUNE 5, 2019

One of the more perplexing problems to troubleshoot in SQL Server can be those related to memory grants. SQL Server’s optimizer estimates how much memory is needed, and the query must obtain the memory grant in order to start executing. sort, hash). If it underestimates memory, then you can see spills in tempdb.

Servers 41

Servers Cache Database Metrics 41

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. Modern network performance and availability. The Moto G4 , for example. Hard Reset.

Performance 124

Performance Network Cache Metrics 124

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. Attempts to access the file with cat, open, ‘ by name ’ fail as the file is no longer available for name resolution. Bob Dorr – Principal Software Engineer SQL Server. Restart the VM.

Servers 40

Servers Software Engineering Systems Monitoring 40

SQL Server According to Bob

JANUARY 29, 2017

Thus, LLDB is not reading the available PT_LOAD headers and the region of memory needed appears after the 65535th entry. FEB 1, 2017 UPDATE – CHANGE ACCEPTED. Bob Dorr – Principal Software Engineer SQL Server. The gdb and readelf utilities read the proper value of (106714) but LLDB used 65535.

Servers 40

Servers Programming Media Open Source 40

SQL Performance

MARCH 17, 2020

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. It would be nice if SQL Server could push the aggregation down into the scan and just return distinct values from the column store directly. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. Even with the broken Java stacks, I noticed a big difference: On Ubuntu, there's a massive amount of CPU time in a libjvm call: os::javaTimeMillis().

Speed 126

Speed Java AWS Virtualization 126