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

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. Before one can design an optimal security approach, it helps to understand what kinds of vulnerabilities are commonly present in web applications. Most common vulnerabilities commonly present in web applications.

Open Source 181

Open Source Entertainment Tuning Internet 181

Scalegrid

JANUARY 11, 2024

Key Takeaways Cloud security monitoring is a comprehensive approach involving both manual and automated processes to oversee servers, applications, platforms, and websites, using tools that are customized to fit unique cloud architectures. This includes servers, applications, software platforms, and websites.

Best Practices 130

Best Practices Cloud Monitoring Strategy 130

Percona

JULY 19, 2023

For example, a table statistics limit is introduced to avoid querying information_schema.tables that may impact DB performance, especially with a high number of DBs / tables present in an instance. In the example, we run PMM server in a docker container. What if you want to change the value later on?

Monitoring 82

Monitoring Entertainment Open Source Tuning 82

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. How we keep you fast and tuned with Adaptive Query Processing and Automatic Tuning. Look for more details on my blog post and the SQL Server Blog about some of these concepts and new features for performance for SQL Server 2017.

Servers 40

Servers Tuning Database Cloud 40

Dynatrace

OCTOBER 23, 2020

At the time of this publication it may not be available there yet, but please stay tuned. Please stay tuned for updates on the location of the Ansible Galaxy collection for OneAgent. Stay tuned for associated announcements about further increments and general availability releases. Operation modes.

Tuning 130

Tuning Monitoring Availability Architecture 130

Dynatrace

AUGUST 12, 2020

Serverless computing is a computing model that “allows you to build and run applications and services without thinking about servers.”. Find out why your request is slow with top findings automatically analyzed and presented by Dynatrace. So stay tuned! Instantly see why a request is slow. What’s next.

Serverless 236

Serverless Azure Monitoring Lambda 236

Percona

FEBRUARY 2, 2023

The only real limitation is that one can only publish tables from a read-write server such as the PRIMARY. When present, redirect other REPLICAs pointing to the new PRIMARY. Stay tuned folks; the game is afoot. DML operations, such as INSERT, UPDATE, DELETE, TRUNCATE, etc., And, of course, timing is critical.

Games 90

Games Open Source Tuning Speed 90

Smashing Magazine

NOVEMBER 8, 2021

From connecting back-office operations to front-of-the-house A/B testing and dynamic personalization for each customer, the shared foundation is fast server-side rendering powered by fast storefront data access. Hydrogen fuels dynamic commerce by uniting React Server Components, streaming server-side rendering, and smart caching controls.

Cache 136

Cache Best Practices Strategy Servers 136

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. I will be looking for distinct values in the BountyAmount column of the dbo.Votes table, presented in bounty amount order ascending. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

The Netflix TechBlog

JUNE 15, 2022

on every incoming search query, we make an API call to the centralized access policy server with context including the identity of the caller making the request and the search index they are trying to access. The policy server evaluates the access policies defined by the source teams and returns a set of constraints.

Engineering 183

Engineering Architecture Availability Tuning 183

Percona

DECEMBER 6, 2023

Additional read Mike’s blog on How to Find and Tune a Slow SQL Query Q: What is your disaster recovery (DR) strategy? In reality, relying solely on a replica under the primary server is not sufficient for a robust disaster recovery plan. The same risk is present while using the password on the command prompt.

Strategy 79

Strategy Database Best Practices Tuning 79

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. This was followed by a greatly expanded second edition with some additional chapters by Rich Pettit.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Dynatrace

MAY 15, 2020

Overcoming the barriers presented by legacy security practices that are typically manually intensive and slow, requires a DevSecOps mindset where security is architected and planned from project conception and automated for speed and scale throughout where possible.

Government 225

Government DevOps Infrastructure Network 225

Dynatrace

AUGUST 12, 2020

Serverless computing is a computing model that “allows you to build and run applications and services without thinking about servers.”. Find out why your request is slow with top findings automatically analyzed and presented by Dynatrace. So stay tuned! Instantly see why a request is slow. What’s next.

Serverless 141

Serverless Azure Monitoring Lambda 141

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. systemctl stop tuned $ systemctl disable tuned Dirty ratio The dirty_ratio is the percentage of total system memory that can hold dirty pages.

Best Practices 52

Best Practices Design Tuning Database 52

SQL Performance

OCTOBER 18, 2022

Before SQL Server 2022, there was a workaround that enabled relying on index order, but besides being quite ugly, it had its cost, and the tradeoff wasn’t always acceptable. SQL Server 2022 introduces new ways to apply time-based grouping using the DATE_BUCKET and DATETRUNC functions. Optimization of Traditional Time-Based Grouping.

Servers 144

Servers Code Best Practices Database 144

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. Is MongoDB free to use?

Open Source 82

Open Source Programming Database Servers 82

Tim Kadlec

APRIL 12, 2020

The cache hit was very low (a topic for another day), and whenever the server had to provide a fresh version of the page, it was taking an unacceptably long time more often than not. Synthetic tests, even properly tuned to match device and network characteristics, only occasionally surfaced the issue.

Tuning 69

Tuning Cache Network Servers 69

Percona

MARCH 19, 2019

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents MySQL Performance Schema in 1 hour on Thursday, March 21st, 2019, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). It was born in 2010 as “a feature for monitoring server execution at a low level.” Register Now.

Tuning 41

Tuning Performance Monitoring Servers 41

Dynatrace

MAY 22, 2019

User sessions queries not only help you focus on the data you really need, they also present returned data to you in whatever way best meets your requirements. And the vast and sleek array of graphs and charts make it easy to present your findings to your colleagues. Stay tuned for more! Ready to give it a try?

Analytics 103

Analytics Tuning Metrics Programming 103

Dynatrace

NOVEMBER 16, 2020

There’s no interaction with the server, but errors might occur because of the different order in which your users interact with the controls. We strive to provide you with the most secure approach by default, so when you select the Block list preset, a list with all the rules applied to the Mask all option is presented to you.

Ecommerce 186

Ecommerce Monitoring Website Tuning 186

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only.

Servers 40

Servers Cache Database Media 40

Percona

OCTOBER 18, 2023

These vendors often provide integrated stacks that include the database, application server, and other components that seamlessly integrate. Database setup To start your migration, you’ll need to install the new open source database software on your server or a cloud platform. — to reflect the specifics of the new database.

Open Source 93

Open Source Database Hardware Strategy 93

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

Percona

FEBRUARY 24, 2023

It’s currently part of our roadmap, so please stay tuned for upcoming releases of PMM and keep an eye on the release notes. Enable Access Control Although Vanessa, a DBA, prefers to enable and configure Access Control via the UI, it is possible to enable it when deploying PMM Server via Docker.

Metrics 108

Metrics Monitoring Database Engineering 108

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented. TheYear , CA.

Servers 95

Servers Tuning Architecture Processing 95

Percona

NOVEMBER 3, 2023

PostgreSQL Cluster One coordinator node citus-coord-01 Three worker nodes citus1 citus2 citus3 Hardware AWS Instance Ubuntu Server 20.04, SSD volume type 64-bit (x86) c5.xlarge Steps Provisioning The first step is to provision the four nodes with both PostgreSQL and Citus. Redundancy can potentially decrease overall performance.

Database 106

Database Benchmarking Latency C++ 106

Dynatrace

FEBRUARY 25, 2021

At AWS re:Invent in 2018, the Lambda team presented an excellent talk. Lambda functions are often used as back ends for static, single-page applications, and many customers asked for the same level of insights they get when running Dynatrace against a regular web server. Stay tuned?for A look under the hood of AWS Lambda.

Lambda 218

Lambda AWS Monitoring Serverless 218

MachMetrics

APRIL 3, 2020

Souders presents his 14 rules throughout the course of the book while discussing the importance of front-end performance. Author Steve Souders writes about the best practices that he gained as the Chief Performance Yahoo!, and the Head Performance Engineer at Google. Resumes don’t get much better than that in this industry.

Speed 85

Speed Performance Best Practices Website 85

Alex Podelko

OCTOBER 20, 2016

Auto-scaling is often presented as a panacea for performance problems, but, even if it is properly implemented (which is, of course, better to be tested), it just assigns a price tag for performance. To get full advantage of cloud, such cloud-specific features as auto-scaling should be implemented.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

Rigor

JANUARY 13, 2020

This book presents 14 specific rules that will cut 25% to 50% off response time when users request a page. As you move ahead with the subset of JavaScript that this book presents, you'll also sidestep the need to unlearn all the bad parts. Web Performance Tuning. How to pioneer new metrics and create a culture of performance.

Performance 75

Performance Social Media Website Website Performance 75

Percona

OCTOBER 17, 2023

Many changes and new features are brought to the system, and as part of keeping in tune with the changes and how they can impact us, we go through the changes to better understand them. From that, this article is born. Our goal here is to review five new changes or implementations you should know in MongoDB 7.0.

Metrics 103

Metrics C++ Storage Database 103

HammerDB

JANUARY 5, 2019

In all cases this is random data so presents no security challenges. If not are you going to “clean” your data so it does not present a security risk? This is especially important as the number of official published benchmarks has reduced over time as shown in the graph from this presentation on TPC relevance.

Benchmarking 40

Benchmarking Database Social Media Scalability 40

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. 0 to Hero: Troubleshooting SQL Server Performance Made Easy – Pedro Lopes.

Engineering 40

Engineering Azure Best Practices Servers 40

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As for tracesys: I investigated the overhead for other syscalls and found it to be negligible, and before I returned to work on it further the kernel code paths changed and it was no longer present in the stacks. 30.14% in the middle of the flame graph.

Speed 126

Speed Java AWS Virtualization 126

SQL Performance

AUGUST 15, 2019

Connecting to SQL Server 2012 or better, or Azure SQL Database. And recommended system configuration: Two or more cores 8GB or more of memory Operating Systems: Windows (8.1 / Server 2012 R2 or better) macOS (10.13 In a new query window, establish a connection to a server, and write or paste a query. NET Core Runtime 2.1

Azure 50

Azure Servers Tuning Operating System 50