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. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning 67

Tuning Servers Database Best Practices 67

Percona

APRIL 17, 2023

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. The Linux default is usually 60 , which is not ideal for database usage.

Best Practices 52

Best Practices Design Tuning Database 52

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. This includes the work done by the server, the client and the intermediary communications networks that transmit data between the two. Reduce Network Requests.

Website Performance 73

Website Performance Website Energy Performance 73

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 109

Availability Database Open Source Hardware 109

Dynatrace

AUGUST 30, 2019

Infrastructure Optimization: 100% improvement in Database Connectivity. Missing Cache Settings – Make sure you cache resources that don’t change often on the browser or use a CDN. That included web servers, app services, microservices, queues, databases, mainframe and external services.

Cache 197

Cache Architecture Database Government 197

Smashing Magazine

AUGUST 3, 2023

You need to beware that slow server response times can significantly increase TTFB, often due to server overload, network issues, or un-optimized logic on the server side. You need to beware of large HTML files or slow network connections because they can lead to longer download times.

Performance 74

Performance Cache Traffic Metrics 74

Smashing Magazine

OCTOBER 2, 2023

for the web app, Sanity CMS, Firebase Auth, and Firestore database. Now, let’s dive into the technical features and best practices that my team adopted in the process of building the WaterBear web app. We used TanStack Query (formerly known as react-query ) for both fetching data and query caching.

Cache 72

Cache Strategy Best Practices Design 72

Dynatrace

APRIL 21, 2022

The Framework is built on five pillars of architectural best practices: Cost optimization. Each pillar brings business and technology leaders together to help organizations choose architecture options that best strategically align to their specific business priorities as they begin their cloud journey. Missing caching layers.

Azure 187

Azure Monitoring Virtualization Metrics 187

All Things Distributed

JUNE 21, 2017

Today, I'm excited to announce the general availability of Amazon DynamoDB Accelerator (DAX) , a fully managed, highly available, in-memory cache that can speed up DynamoDB response times from milliseconds to microseconds, even at millions of requests per second. Adding caching when your app is already experiencing load is not easy.

Speed 121

Speed Cache Latency AWS 121

IO River

NOVEMBER 2, 2023

It’s not just limited to cloud resources like AWS and Azure; Terraform is versatile, extending its capabilities to key performance areas like Content Delivery Network (CDN) management, ensuring efficient content delivery and optimal user experience.‍Started This level of granularity is not found in UI-managed systems.Â

Open Source 52

Open Source DevOps AWS Azure 52

IO River

NOVEMBER 2, 2023

When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits. Their expertise lies in ensuring everything runs smoothly, from servers to networks. AutomationCode-based systems also shine in automation.

Open Source 40

Open Source DevOps AWS Azure 40

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? KB boundary   12 Larger transaction logs   13 Restore and attach   14 Format for 4 ?KB

Servers 40

Servers Cache Database Media 40

Smashing Magazine

NOVEMBER 30, 2021

We last talked to him in July 2020 , where we asked if modern best practices about for the web. Last time we talked, we posed this question of if modern best practices, the use of reactive frameworks and these sorts of things were actually bad for the progress of the web. Drew: You want it to remain unspoiled.

Technology 94

Technology Technology Servers Code 94

Smashing Magazine

NOVEMBER 12, 2021

The plugin provides useful warnings and hints on the best practices. Particularly, when dealing with web sockets, you may need to unsubscribe from the network to save resources and improve performance when the component unmounts. Memoization simply means caching. Fetching And Refetching Data With useEffect.

Code 118

Code Availability Efficiency Performance 118

Smashing Magazine

JANUARY 6, 2020

If you don’t have a device at hand, emulate mobile experience on desktop by testing on a throttled 3G network (e.g. To make the performance impact more visible, you could even introduce 2G Tuesdays or set up a throttled 3G/4G network in your office for faster testing. 300ms RTT, 1.6 Mbps down, 0.8

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 7, 2019

If you don’t have a device at hand, emulate mobile experience on desktop by testing on a throttled network (e.g. To make the performance impact more visible, you could even introduce 2G Tuesdays or set up a throttled 3G network in your office for faster testing. 150ms RTT, 1.5 Mbps down, 0.7 Mbps up) with a throttled CPU (5× slowdown).

Performance 104

Performance Cache Network Metrics 104